APPS.GMS_AWARDS_BOUNDARY_DATES_CHK dependencies on PO_REQ_DISTRIBUTIONS_ALL

Line 121: po_req_distributions_all req

117: FROM DUAL
118: WHERE EXISTS
119: (SELECT 'X'
120: FROM gms_award_distributions adl,
121: po_req_distributions_all req
122: WHERE adl.distribution_id = req.distribution_id
123: AND adl.adl_status = 'A'
124: AND adl.award_id = P_AWARD_ID
125: AND req.expenditure_item_date < P_START_DATE) ;

Line 337: po_req_distributions_all req

333: FROM DUAL
334: WHERE EXISTS
335: (SELECT 'X'
336: FROM gms_award_distributions adl,
337: po_req_distributions_all req
338: WHERE adl.distribution_id = req.distribution_id
339: AND adl.adl_status = 'A'
340: AND adl.award_id = P_AWARD_ID
341: AND req.expenditure_item_date > P_END_DATE) ;

Line 627: FROM po_req_distributions_all req

623: SELECT 1
624: FROM DUAL
625: WHERE EXISTS
626: (SELECT 'X'
627: FROM po_req_distributions_all req
628: WHERE req.project_id = P_PROJECT_ID
629: AND req.task_id = nvl(P_TASK_ID, req.task_id)
630: AND req.expenditure_item_date < P_START_DATE) ;
631:

Line 880: FROM po_req_distributions_all req

876: SELECT 1
877: FROM DUAL
878: WHERE EXISTS
879: (SELECT 'X'
880: FROM po_req_distributions_all req
881: WHERE req.project_id = P_PROJECT_ID
882: AND req.task_id = nvl(P_TASK_ID, req.task_id)
883: AND req.expenditure_item_date > P_COMPLETION_DATE) ;
884: