<?xml version="1.0" encoding="UTF-8"?>

<bm:model xmlns:bm="http://www.leaf-framework.org/schema/bm">
    <bm:operations>
        <bm:operation name="query">
            <bm:query-sql><![CDATA[
                select h.bp_name agent_name,h.bp_id agent_id
                from hls_bp_master h
                where h.unit_id =
                (select eo.unit_id
                from exp_org_position eo
                where eo.position_id =
                (select ee.POSITION_ID
                from EXP_EMPLOYEE_ASSIGNS ee
                where ee.EMPLOYEE_ID =
                (select s.employee_id
                from sys_user s
                where ${/session/@user_id} = s.user_id))
                and (select eou.parent_unit_id
                from EXP_ORG_UNIT eou
                where eou.unit_id = eo.unit_id) = 1544)
                ]]>
            </bm:query-sql>
        </bm:operation>
    </bm:operations>
</bm:model>
