<?xml version="1.0" encoding="UTF-8"?>
<!--
    $Author: wujun  
    $Date: 2016-12-15 11:06:10  
    $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 ppb.bp_name
			  from prj_project_bp ppb
			 where ppb.bp_category = 'GUARANTOR'
			   and ppb.project_id = (select cc.project_id
			                           from con_contract_cashflow ccc, con_contract cc
			                          where cc.contract_id = ccc.contract_id
			                            and ccc.cashflow_id = ${@cashflow_id})
			     ]]></bm:query-sql>
            <bm:parameters>
                <bm:parameter name="cashflow_id"/>
            </bm:parameters>
        </bm:operation>
    </bm:operations>
</bm:model>
