<?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 hpcabfl.bp_name,
            	   rownum sequence,
			       hpcabfl.bp_type_n, --项目角色
			       hpcbdl.point_side,           --预警因素
			       hpcbdl.point_check_status_n  --检查结论
			from hn_prj_check_actual_bp_f_lv hpcabfl,
			     hn_prj_check_bp_detail_lv hpcbdl
			where hpcabfl.check_bp_id = hpcbdl.check_bp_id AND
				  hpcabfl.bp_type_n = '次承租人' AND
			      hpcabfl.check_id = ${@check_id}
			      ]]></bm:query-sql>
            <bm:parameters>
                <bm:parameter name="check_id"/>
            </bm:parameters>
        </bm:operation>
    </bm:operations>
</bm:model>
