<?xml version="1.0" encoding="UTF-8"?>
<!--
    $Author: 38823
    $Revision: 1.0
    $Purpose:
-->
<bm:model xmlns:bm="http://www.leaf-framework.org/schema/bm" needAccessControl="false">
    <bm:operations>
        <bm:operation name="query">
            <bm:query-sql><![CDATA[
                select t.division from (select hb.division,ee.user_id
  from exp_emp_assign_e_v           ee,
       hls_bp_master                h,
       hls_bp_master_agent_division hb
 where ee.unit_id = h.unit_id
   and h.bp_id = hb.bp_id
   and h.bp_category = 'AGENT') t #WHERE_CLAUSE#
            ]]></bm:query-sql>
        </bm:operation>
    </bm:operations>
    <bm:query-fields>
        <bm:query-field name="user_id" queryExpression="t.user_id=${@user_id}"/>
    </bm:query-fields>
</bm:model>
