APPS.GMS_AWARDS_BOUNDARY_DATES_CHK dependencies on PA_EXPENDITURE_ITEMS_ALL

Line 27: pa_expenditure_items_all exp

23: FROM DUAL
24: WHERE EXISTS
25: (SELECT 'X'
26: FROM gms_award_distributions adl,
27: pa_expenditure_items_all exp
28: WHERE adl.expenditure_item_id = exp.expenditure_item_id
29: AND adl.document_type = 'EXP'
30: AND adl.adl_status = 'A'
31: AND adl.award_id = P_AWARD_ID

Line 252: pa_expenditure_items_all exp

248: FROM DUAL
249: WHERE EXISTS
250: (SELECT 'X'
251: FROM gms_award_distributions adl,
252: pa_expenditure_items_all exp
253: WHERE adl.expenditure_item_id = exp.expenditure_item_id
254: AND adl.document_type = 'EXP'
255: AND adl.adl_status = 'A'
256: AND adl.award_id = P_AWARD_ID

Line 567: FROM pa_expenditure_items_all exp

563: SELECT 1
564: FROM DUAL
565: WHERE EXISTS
566: (SELECT 'X'
567: FROM pa_expenditure_items_all exp
568: /* pa_tasks tsk 4138033 */
569: WHERE /*exp.task_id = tsk.task_id
570: AND */ exp.project_id = P_PROJECT_ID
571: and exp.task_id = nvl(P_TASK_ID, exp.task_id)

Line 849: FROM pa_expenditure_items_all exp

845: SELECT 1
846: FROM DUAL
847: WHERE EXISTS
848: (SELECT 'X'
849: FROM pa_expenditure_items_all exp
850: /* pa_tasks tsk */
851: WHERE /* exp.task_id = tsk.task_id
852: AND */ exp.project_id = P_PROJECT_ID
853: AND exp.task_id = nvl(P_TASK_ID, exp.task_id)