APPS.GMS_AWARDS_BOUNDARY_DATES_CHK dependencies on PO_REQUISITION_LINES_ALL

Line 128: po_requisition_lines_all pol --Bug 7660803 / 8250302

124: WHERE EXISTS
125: (SELECT 'X'
126: FROM gms_award_distributions adl,
127: po_req_distributions_all req ,
128: po_requisition_lines_all pol --Bug 7660803 / 8250302
129: WHERE adl.distribution_id = req.distribution_id
130: AND adl.adl_status = 'A'
131: AND adl.award_id = P_AWARD_ID
132: AND req.expenditure_item_date < P_START_DATE

Line 353: po_requisition_lines_all pol --Bug 7660803 /8250302

349: WHERE EXISTS
350: (SELECT 'X'
351: FROM gms_award_distributions adl,
352: po_req_distributions_all req ,
353: po_requisition_lines_all pol --Bug 7660803 /8250302
354: WHERE adl.distribution_id = req.distribution_id
355: AND adl.adl_status = 'A'
356: AND adl.award_id = P_AWARD_ID
357: AND req.expenditure_item_date > P_END_DATE

Line 671: po_requisition_lines_all pol --Bug 8431879

667: FROM DUAL
668: WHERE EXISTS
669: (SELECT 'X'
670: FROM po_req_distributions_all req,
671: po_requisition_lines_all pol --Bug 8431879
672: WHERE req.project_id = P_PROJECT_ID
673: AND req.task_id = nvl(P_TASK_ID, req.task_id)
674: AND req.expenditure_item_date < P_START_DATE
675: AND req.requisition_line_id = pol.requisition_line_id --Bug 8431879

Line 955: po_requisition_lines_all pol --Bug 8431879

951: FROM DUAL
952: WHERE EXISTS
953: (SELECT 'X'
954: FROM po_req_distributions_all req,
955: po_requisition_lines_all pol --Bug 8431879
956: WHERE req.project_id = P_PROJECT_ID
957: AND req.task_id = nvl(P_TASK_ID, req.task_id)
958: AND req.expenditure_item_date > P_COMPLETION_DATE
959: AND req.requisition_line_id = pol.requisition_line_id --Bug 8431879