<?xml version="1.0" encoding="UTF-8"?>
<!--
    $Author: weiwuzhen  
    $Date: 2016-7-13 下午1:38:45  
    $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 br.bank_branch_name, --付款开户行
			       ca.bank_account_num, --付款帐号
			       to_char(cb.amount,'FM999,999,999,990.00') amount --付款金额 
			  FROM CSH_PAYMENT_REQ_LN_BANK cb,
			       csh_payment_req_ln      l,
			       CSH_BANK_ACCOUNT        ca,
			       csh_bank_branch         br
			 where cb.payment_req_ln_id = l.payment_req_ln_id
			   and cb.bank_account_id = ca.bank_account_id
			   and ca.bank_branch_id = br.bank_branch_id
			   and l.payment_req_id =${/parameter/@payment_req_id}
			   ]]></bm:query-sql>
        </bm:operation>
    </bm:operations>
</bm:model>
