APPS.PA_TRANS_UTILS dependencies on PA_EXPENDITURE_ITEMS_ALL

Line 38: FROM pa_expenditure_items_all ei

34: ,'ERROR' ) error_msg_code
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

Line 58: FROM pa_expenditure_items_all ei

54: ,'ERROR' ) error_msg_code
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

Line 80: FROM pa_expenditure_items_all ei

76: ,'ERROR' ) error_msg_code
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