DBA Data[Home] [Help]

APPS.GMS_GROUP_REVERSAL_PKG dependencies on PA_EXPENDITURES_ALL

Line 24: ,pa_expenditures_all e2

20: e1.last_update_login ,
21: e1.adjusted_expenditure_item_id
22:
23: from pa_expenditure_items_all e1
24: ,pa_expenditures_all e2
25:
26: where e2.expenditure_group = x_reverse_group
27: and e2.expenditure_id = e1.expenditure_id ;
28: BEGIN

Line 99: ,pa_expenditures_all e2

95: e1.last_updated_by ,
96: e1.last_update_login
97:
98: from pa_expenditure_items_all e1
99: ,pa_expenditures_all e2
100:
101: where e2.expenditure_group = x_new_group
102: and e2.expenditure_id = e1.expenditure_id
103: and e1.expenditure_type = x_expenditure_type

Line 124: ,pa_expenditures_all e2

120: e1.last_updated_by ,
121: e1.last_update_login
122:
123: from pa_expenditure_items_all e1
124: ,pa_expenditures_all e2
125: ,pa_expenditure_groups_all e3
126: where e3.expenditure_group = x_org_group
127: and e3.expenditure_group = e2.expenditure_group
128: and e2.expenditure_id = e1.expenditure_id ;