44: AND L.po_line_id = D.po_line_id;
45:
46: CURSOR C_Req_Line ( C_Line_ID NUMBER ) IS
47: SELECT distinct L.oke_contract_header_id , D.oke_contract_line_id
48: FROM po_req_distributions_all D , po_requisition_lines_all L
49: WHERE D.requisition_line_id = C_Line_ID
50: AND L.requisition_line_id = D.requisition_line_id;
51:
52: CURSOR C_Req_Dist ( C_Dist_ID NUMBER ) IS
50: AND L.requisition_line_id = D.requisition_line_id;
51:
52: CURSOR C_Req_Dist ( C_Dist_ID NUMBER ) IS
53: SELECT L.oke_contract_header_id , D.oke_contract_line_id , D.project_id , D.task_id
54: FROM po_req_distributions_all D , po_requisition_lines_all L
55: WHERE D.distribution_id = C_Dist_ID
56: AND L.requisition_line_id = D.requisition_line_id;
57:
58: CURSOR C_Shipping ( C_Delivery_detail_ID NUMBER ) IS