<?xml version="1.0" encoding="UTF-8"?>
<!--
    $Author: 18083
    $Date:  
    $Revision: 1.0  
    $Purpose: 
-->
<bm:model xmlns:bm="http://www.leaf-framework.org/schema/bm">
    <bm:operations>
        <bm:operation name="query">
            <bm:query-sql><![CDATA[
       select
       t.bank_account_num  vender_bank_account_number,
      t.bank_account_name vender_bank_account_name,
      bank_account_id    vender_bank_account_id,
      t.bank_full_name vender_bank_full_name,
     (select bp_name from hls_bp_master  hbm where hbm.bp_id=t.bp_id) vender_name
  from hls_bp_master_bank_account_v t
 where t.bp_id = (
    select hli.vender_id
   from hls_lease_item hli,con_contract_lease_item ccli
   where hli.lease_item_id=ccli.lease_item_id
        and ccli.contract_id=${/parameter/@contract_id}
   )
   and t.enabled_flag = 'Y'

           ]]></bm:query-sql>
        </bm:operation>
    </bm:operations>
</bm:model>
