<?xml version="1.0" encoding="UTF-8"?>
<bm:model xmlns:ns2="leaf.database.local.oracle" xmlns:f="leaf.database.features" xmlns:bm="http://www.leaf-framework.org/schema/bm">
    <bm:operations>
        <bm:operation name="query">
            <bm:query-sql><![CDATA[
              Select t1.*,replace(t1.service_url,
                                    'modules/prj/PRJ501N/prj_project_maintain_wfl_new.lview',
                                    'modules/prj/PRJ501N/prj_project_maintain_constru_wfl.lview') as service_url_constru,
				 replace(t1.service_url,
                                                  'modules/prj/PRJ501N/prj_project_maintain_wfl_new.lview',
                                                  'modules/prj/PRJ501N/prj_project_maintain_operat_wfl.lview') as service_url_operat,
			    replace(t1.service_url,
                                                                'modules/csh/CSH501/csh_payment_req.lview',
                                                                'modules/csh/CSH501/csh_payment_op_req.lview') as service_url_operat_payment

                    ,zj_wfl_core_pkg.get_parameter_value(p_instance_id => t1.instance_id,
                                           p_parameter_name => 'PROJECT_ID') PROJECT_ID
                    ,(select sp.parameter_value
                          from zj_wfl_workflow_service      zs,
                               zj_wfl_workflow_service_para zp,
                               zj_wfl_workflow_node_svc_para sp
                         where zs.service_name =
                               'modules/prj/PRJ501N/prj_project_maintain_wfl_new.lview'
                           and zp.service_id = zs.service_id
                           and sp.parameter_id = zp.service_para_id
                           and zp.parameter_code = 'show_project_history_flag'
                           and sp.source_type = 'DISPLAY'
                           and sp.node_id = t1.node_id
                           ) show_project_history_flag
               From (select zj_wfl_core_pkg.get_node_service_url(tt.record_id,
                                    ${/parameter/@url_type},
                                    ${/session/@user_id}) as service_url,tt.*
          from zj_wfl_instance_node_recipient tt) t1
         #WHERE_CLAUSE#
          ]]></bm:query-sql>
        </bm:operation>
    </bm:operations>
</bm:model>
