[Home] [Help]
94: l_cwk_rlmi Number := NULL;
95:
96: CURSOR cur_pkt_cwk_rlmi IS
97: SELECT resource_list_member_id
98: FROM pa_bc_packets pkt
99: WHERE pkt.project_id = p_project_id
100: AND pkt.task_id = p_task_id
101: AND pkt.budget_version_id = p_budget_version_id
102: AND ((p_document_type = 'PO'
354: AND NVL(pt.burden_amt_display_method,'N') = 'D';
355:
356: CURSOR cur_pktsumRecInfo(p_project_id Number,p_task_id Number,p_doc_line_id Number ) IS
357: SELECT sm.expenditure_type
358: FROM pa_bc_packets sm
359: ,pa_projects_all pp
360: ,pa_project_types_all pt
361: WHERE sm.summary_record_flag = 'Y'
362: AND sm.project_id = p_project_id