APPS.GMS_AWARDS_BOUNDARY_DATES_CHK dependencies on PO_DISTRIBUTIONS_ALL

Line 94: po_distributions_all po

90: FROM DUAL
91: WHERE EXISTS
92: (SELECT 'X'
93: FROM gms_award_distributions adl,
94: po_distributions_all po
95: WHERE adl.po_distribution_id = po.po_distribution_id
96: AND adl.adl_status = 'A'
97: AND adl.award_id = P_AWARD_ID
98: AND adl.award_set_id = po.award_id -- Bug 3985177

Line 310: po_distributions_all po

306: FROM DUAL
307: WHERE EXISTS
308: (SELECT 'X'
309: FROM gms_award_distributions adl,
310: po_distributions_all po
311: WHERE adl.po_distribution_id = po.po_distribution_id
312: AND adl.adl_status = 'A'
313: AND adl.award_id = P_AWARD_ID
314: AND adl.award_set_id = po.award_id -- Bug 3985177

Line 603: FROM po_distributions_all po

599: SELECT 1
600: FROM DUAL
601: WHERE EXISTS
602: (SELECT 'X'
603: FROM po_distributions_all po
604: WHERE po.project_id = P_PROJECT_ID
605: AND po.task_id = nvl(P_TASK_ID, po.task_id)
606: AND po.expenditure_item_date < P_START_DATE) ;
607:

Line 856: FROM po_distributions_all po

852: SELECT 1
853: FROM DUAL
854: WHERE EXISTS
855: (SELECT 'X'
856: FROM po_distributions_all po
857: WHERE po.project_id = P_PROJECT_ID
858: AND po.task_id = nvl(P_TASK_ID, po.task_id)
859: AND po.expenditure_item_date > P_COMPLETION_DATE) ;
860: