DBA Data[Home] [Help]

APPS.GMS_EXP_ADJUSTMENT_PKG dependencies on PA_EXPENDITURES_ALL

Line 37: ,pa_expenditures_all e2

33: e1.last_update_date ,
34: e1.last_updated_by ,
35: e1.last_update_login
36: from pa_expenditure_items_all e1
37: ,pa_expenditures_all e2
38:
39: where e2.expenditure_group = x_new_group
40: and e2.expenditure_id = e1.expenditure_id
41: and e1.expenditure_type = x_expenditure_type

Line 65: ,pa_expenditures_all e2

61: e1.last_updated_by ,
62: e1.last_update_login
63:
64: from pa_expenditure_items_all e1
65: ,pa_expenditures_all e2
66: ,pa_expenditure_groups_all e3
67: where e3.expenditure_group = x_org_group
68: and e3.expenditure_group = e2.expenditure_group
69: and e2.expenditure_id = e1.expenditure_id

Line 177: ,pa_expenditures_all e2

173: e1.last_update_login ,
174: e1.adjusted_expenditure_item_id
175:
176: from pa_expenditure_items_all e1
177: ,pa_expenditures_all e2
178:
179: where e2.expenditure_group = x_reverse_group
180: and e2.expenditure_id = e1.expenditure_id ;
181: BEGIN