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 243: pa_expenditure_items_all exp

239: FROM DUAL
240: WHERE EXISTS
241: (SELECT 'X'
242: FROM gms_award_distributions adl,
243: pa_expenditure_items_all exp
244: WHERE adl.expenditure_item_id = exp.expenditure_item_id
245: AND adl.document_type = 'EXP'
246: AND adl.adl_status = 'A'
247: AND adl.award_id = P_AWARD_ID

Line 549: FROM pa_expenditure_items_all exp

545: SELECT 1
546: FROM DUAL
547: WHERE EXISTS
548: (SELECT 'X'
549: FROM pa_expenditure_items_all exp
550: /* pa_tasks tsk 4138033 */
551: WHERE /*exp.task_id = tsk.task_id
552: AND */ exp.project_id = P_PROJECT_ID
553: and exp.task_id = nvl(P_TASK_ID, exp.task_id)

Line 803: FROM pa_expenditure_items_all exp

799: SELECT 1
800: FROM DUAL
801: WHERE EXISTS
802: (SELECT 'X'
803: FROM pa_expenditure_items_all exp
804: /* pa_tasks tsk */
805: WHERE /* exp.task_id = tsk.task_id
806: AND */ exp.project_id = P_PROJECT_ID
807: AND exp.task_id = nvl(P_TASK_ID, exp.task_id)