163: Where Vendor_Id = p_old_vendor_id
164: And Status_Code = 'A';
165:
166: --R12 need to update vendor ID on pa_bc_commitments
167: x_stage := 'Updating Pa_Bc_Commitments_All Table';
168: Update pa_bc_commitments_all
169: set Vendor_Id = p_new_vendor_id
170: Where Vendor_Id = p_old_vendor_id;
171:
164: And Status_Code = 'A';
165:
166: --R12 need to update vendor ID on pa_bc_commitments
167: x_stage := 'Updating Pa_Bc_Commitments_All Table';
168: Update pa_bc_commitments_all
169: set Vendor_Id = p_new_vendor_id
170: Where Vendor_Id = p_old_vendor_id;
171:
172: x_stage := 'Updating Pa_Project_Asset_Lines_All Table For ALL Invoices';