APPS.PAY_CA_CITY_UPD dependencies on PER_ADDRESSES

Line 228: hr_utility.trace('Starting bulk update on per_addresses ');

224: FOR j IN v_old_city.first..v_old_city.last LOOP
225: v_prov(j) := prov_abbrev(v_county_code(j));
226: END LOOP;
227:
228: hr_utility.trace('Starting bulk update on per_addresses ');
229:
230: FORALL j IN v_old_city.first..v_old_city.last
231: UPDATE per_addresses
232: SET town_or_city = substrb(v_new_city(j),1,30),

Line 231: UPDATE per_addresses

227:
228: hr_utility.trace('Starting bulk update on per_addresses ');
229:
230: FORALL j IN v_old_city.first..v_old_city.last
231: UPDATE per_addresses
232: SET town_or_city = substrb(v_new_city(j),1,30),
233: derived_locale = decode(derived_locale, NULL, NULL,
234: get_derived_locale(v_new_city(j),country))
235: WHERE region_1 = v_prov(j)

Line 270: hr_utility.trace('Completed update on per_addresses,hr_locations_all and pay_us_city_names');

266: END IF;
267:
268: END LOOP;
269:
270: hr_utility.trace('Completed update on per_addresses,hr_locations_all and pay_us_city_names');
271:
272: CLOSE city_mappings;
273:
274: EXCEPTION