<?xml version="1.0" encoding="UTF-8"?>
<!--
    $Author: weiwuzhen  
    $Date: 2016-5-20 下午5:31:11  
    $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 p.project_id,
       p.chance_id,
        nvl(zr.comment_text,zr.action_type_desc)      project_review_post, --业务部负责人审核                              
       p.lease_organization,
       zr.approver         user_desc2
  from prj_project              p,
       zj_wfl_approve_history_v zr,
       zj_wfl_workflow_instance zi
 where zr.instance_approve_count = zi.approve_count
   and zr.instance_id = zi.instance_id
   and p.wfl_instance_id = zi.instance_id
   and zr.node_code = 'PROJECT_REP_APPROVE_10'
 
   and p.project_id=${/parameter/@project_id}
   ]]></bm:query-sql>
        </bm:operation>
    </bm:operations>
</bm:model>
