125: ) ;
126:
127: CURSOR cur_com_cwk_rlmi IS
128: SELECT resource_list_member_id
129: FROM pa_bc_commitments_all com
130: WHERE com.project_id = p_project_id
131: AND com.task_id = p_task_id
132: AND com.budget_version_id = p_budget_version_id
133: AND ((p_document_type = 'PO'
316: l_no_costplus_structure Exception;
317:
318: CURSOR cur_comsumRecInfo (p_project_id Number,p_task_id Number,p_doc_line_id Number ) IS
319: SELECT sm.expenditure_type
320: FROM pa_bc_commitments_all sm
321: ,pa_projects_all pp
322: ,pa_project_types_all pt
323: WHERE sm.summary_record_flag = 'Y'
324: AND sm.project_id = p_project_id