APPS.GMS_FUNDS_CONTROL_PKG dependencies on PO_REQ_DISTRIBUTIONS

Line 1362: po_req_distributions pd

1358: -- Bug 2155774, Cursor to pick all the REQ distributions not having adls
1359: CURSOR c_REQ_miss_adls (p_distribution_id NUMBER) IS
1360: SELECT adl.award_set_id, adl.adl_status
1361: FROM gms_award_distributions adl,
1362: po_req_distributions pd
1363: WHERE pd.distribution_id = p_distribution_id
1364: AND pd.award_id = adl.award_set_id
1365: AND adl.adl_line_num = 1
1366: AND not exists (select 1 from gms_award_distributions gad

Line 1418: po_req_distributions_all pd

1414: SET adl_status = 'I'
1415: WHERE adl.adl_status = 'A'
1416: AND (adl.award_set_id,adl.document_type) IN ( SELECT adl2.award_set_id,adl2.document_type
1417: FROM gms_award_distributions adl2,
1418: po_req_distributions_all pd
1419: WHERE g_document_type_tab(i) = 'REQ'
1420: AND adl2.document_type = 'REQ'
1421: AND adl2.adl_line_num = 1
1422: AND adl2.distribution_id = pd.distribution_id

Line 2653: po_req_distributions_all pord,

2649: pov.vendor_id,
2650: adl.ind_compiled_set_id
2651: FROM gms_award_distributions adl,
2652: po_requisition_lines_all porl,
2653: po_req_distributions_all pord,
2654: po_vendors pov
2655: WHERE pord.distribution_id = p_req_dist_id
2656: AND pord.project_id IS NOT NULL
2657: AND NVL (pord.award_id, l_dist_award_id) = adl.award_set_id