csh_query_position.lwm

<?xml version="1.0" encoding="UTF-8"?>
<bm:model xmlns:bm="http://www.leaf-framework.org/schema/bm" xmlns:f="leaf.database.features">
    <bm:operations>
        <bm:operation name="query">
            <bm:query-sql><![CDATA[
               select p.position_code, 'Y' approval_enbale
                FROM exp_emp_user_e_v e, exp_org_position p where e.position_id = p.POSITION_ID and e.user_id = ${/session/@user_id}
                and p.position_code in ('014','009') and p.ENABLED_FLAG = 'Y'
                ]]>
            </bm:query-sql>
        </bm:operation>
    </bm:operations>
</bm:model>