<?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 rownum,
		        hpcab.bp_id,
		       (select hbm.bp_name from hls_bp_master hbm where hbm.bp_id = hpcab.bp_id) bp_name,
		       hpcab.bp_category,
		       (select hbc.description
		          from hls_bp_category hbc
		         where hbc.bp_category = hpcab.bp_category) bp_category_n,
		       hpcab.bp_type,
		       (select hbt.description
		          from hls_bp_type hbt
		         where hbt.bp_type = hpcab.bp_type) bp_type_n
		 from hn_prj_check_actual_bp hpcab 
		 where hpcab.check_id =${@check_id} and hpcab.data_class='FIN' order by hpcab.bp_category desc,hpcab.bp_type
		 		]]></bm:query-sql>
            <bm:parameters>
                <bm:parameter name="check_id"/>
            </bm:parameters>
        </bm:operation>
    </bm:operations>
</bm:model>
