DBA Data[Home] [Help]

APPS.PA_AP_INTEGRATION dependencies on PA_EXPENDITURES_ALL

Line 17: x_stage := 'Updating Pa_Expenditures_All Table';

13: x_stage := 'Updating Pa_implementations Table';
14: Update pa_implementations_all set Vendor_Id = p_new_vendor_id
15: Where Vendor_Id = p_old_vendor_id;
16:
17: x_stage := 'Updating Pa_Expenditures_All Table';
18:
19: /*Code change for 7125912 */
20: UPDATE pa_expenditures_all e
21: SET e.vendor_id = p_new_vendor_id

Line 20: UPDATE pa_expenditures_all e

16:
17: x_stage := 'Updating Pa_Expenditures_All Table';
18:
19: /*Code change for 7125912 */
20: UPDATE pa_expenditures_all e
21: SET e.vendor_id = p_new_vendor_id
22: WHERE e.vendor_id = p_old_vendor_id
23: AND e.expenditure_id in (
24: SELECT ---- /*+ LEADING(ei) */