APPS.GMS_AWARDS_BOUNDARY_DATES_CHK dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 109: ap_invoice_distributions_all ap

105: FROM DUAL
106: WHERE EXISTS
107: (SELECT 'X'
108: FROM gms_award_distributions adl,
109: ap_invoice_distributions_all ap
110: WHERE adl.invoice_distribution_id = ap.invoice_distribution_id
111: AND adl.adl_status = 'A'
112: AND adl.award_id = P_AWARD_ID
113: AND ap.expenditure_item_date < P_START_DATE );

Line 325: ap_invoice_distributions_all ap

321: FROM DUAL
322: WHERE EXISTS
323: (SELECT 'X'
324: FROM gms_award_distributions adl,
325: ap_invoice_distributions_all ap
326: WHERE adl.invoice_distribution_id = ap.invoice_distribution_id
327: AND adl.adl_status = 'A'
328: AND adl.award_id = P_AWARD_ID
329: AND ap.expenditure_item_date > P_END_DATE );

Line 615: FROM ap_invoice_distributions_all ap

611: SELECT 1
612: FROM DUAL
613: WHERE EXISTS
614: (SELECT 'X'
615: FROM ap_invoice_distributions_all ap
616: WHERE ap.project_id = P_PROJECT_ID
617: AND ap.task_id = nvl(P_TASK_ID, ap.task_id)
618: AND ap.expenditure_item_date < P_START_DATE) ;
619:

Line 868: FROM ap_invoice_distributions_all ap

864: SELECT 1
865: FROM DUAL
866: WHERE EXISTS
867: (SELECT 'X'
868: FROM ap_invoice_distributions_all ap
869: WHERE ap.project_id = P_PROJECT_ID
870: AND ap.task_id = nvl(P_TASK_ID, ap.task_id)
871: AND ap.expenditure_item_date > P_COMPLETION_DATE) ;
872: