APPS.PA_TRANS_UTILS dependencies on PA_EXPENDITURES_ALL

Line 39: ,pa_expenditures_all exp

35: FROM dual
36: WHERE EXISTS
37: ( SELECT 'Y'
38: FROM pa_expenditure_items_all ei
39: ,pa_expenditures_all exp
40: WHERE exp.INCURRED_BY_PERSON_ID = p_person_id
41: AND exp.expenditure_id = ei.expenditure_id
42: AND ei.project_id = p_project_id
43: AND ei.assignment_id = p_assignment_id

Line 59: ,pa_expenditures_all exp

55: FROM dual
56: WHERE EXISTS
57: ( SELECT 'Y'
58: FROM pa_expenditure_items_all ei
59: ,pa_expenditures_all exp
60: WHERE exp.INCURRED_BY_PERSON_ID = p_person_id
61: AND exp.EXPENDITURE_ENDING_DATE between p_old_start_date and p_old_end_date
62: AND exp.expenditure_id = ei.expenditure_id
63: AND ei.project_id = p_project_id

Line 81: ,pa_expenditures_all exp

77: FROM dual
78: WHERE EXISTS
79: ( SELECT 'Y'
80: FROM pa_expenditure_items_all ei
81: ,pa_expenditures_all exp
82: WHERE exp.INCURRED_BY_PERSON_ID = p_person_id
83: AND exp.EXPENDITURE_ENDING_DATE between p_new_start_date and p_new_end_date
84: AND exp.expenditure_id = ei.expenditure_id
85: AND ei.project_id = p_project_id