APPS.GMS_FUNDS_CONTROL_PKG dependencies on PO_REQ_DISTRIBUTIONS

Line 1333: po_req_distributions pd

1329: -- Bug 2155774, Cursor to pick all the REQ distributions not having adls
1330: CURSOR c_REQ_miss_adls (p_distribution_id NUMBER) IS
1331: SELECT adl.award_set_id, adl.adl_status
1332: FROM gms_award_distributions adl,
1333: po_req_distributions pd
1334: WHERE pd.distribution_id = p_distribution_id
1335: AND pd.award_id = adl.award_set_id
1336: AND adl.adl_line_num = 1
1337: AND not exists (select 1 from gms_award_distributions gad

Line 1389: po_req_distributions_all pd

1385: SET adl_status = 'I'
1386: WHERE adl.adl_status = 'A'
1387: AND (adl.award_set_id,adl.document_type) IN ( SELECT adl2.award_set_id,adl2.document_type
1388: FROM gms_award_distributions adl2,
1389: po_req_distributions_all pd
1390: WHERE g_document_type_tab(i) = 'REQ'
1391: AND adl2.document_type = 'REQ'
1392: AND adl2.adl_line_num = 1
1393: AND adl2.distribution_id = pd.distribution_id

Line 2427: po_req_distributions_all pord,

2423: pov.vendor_id,
2424: adl.ind_compiled_set_id
2425: FROM gms_award_distributions adl,
2426: po_requisition_lines_all porl,
2427: po_req_distributions_all pord,
2428: po_vendors pov
2429: WHERE pord.distribution_id = p_req_dist_id
2430: AND pord.project_id IS NOT NULL
2431: AND NVL (pord.award_id, l_dist_award_id) = adl.award_set_id