APPS.PAY_US_USER_CITY_UPGRADE_PKG dependencies on PAY_US_CITY_NAMES

Line 380: l_city_name pay_us_city_names.city_name%TYPE;

376: l_error_assignments NUMBER;
377: l_assignments_to_be_updated NUMBER;
378: l_old_juri_code pay_us_geo_update.old_juri_code%TYPE;
379: l_new_juri_code pay_us_geo_update.new_juri_code%TYPE;
380: l_city_name pay_us_city_names.city_name%TYPE;
381: l_primary_flag pay_us_city_names.primary_flag%TYPE;
382:
383: BEGIN
384:

Line 381: l_primary_flag pay_us_city_names.primary_flag%TYPE;

377: l_assignments_to_be_updated NUMBER;
378: l_old_juri_code pay_us_geo_update.old_juri_code%TYPE;
379: l_new_juri_code pay_us_geo_update.new_juri_code%TYPE;
380: l_city_name pay_us_city_names.city_name%TYPE;
381: l_primary_flag pay_us_city_names.primary_flag%TYPE;
382:
383: BEGIN
384:
385: hr_utility.trace('Entering pay_us_user_city_upgrade_pkg.deinitialization');

Line 488: UPDATE pay_us_city_names

484: LOOP
485:
486: /*Update the City Code and Primary Flag as shipped by Oracle*/
487:
488: UPDATE pay_us_city_names
489: SET city_code = substr(l_new_juri_code,8,4),
490: primary_flag = l_primary_flag
491: WHERE state_code = substr(l_old_juri_code,1,2)
492: AND county_code = substr(l_old_juri_code,4,3)

Line 764: l_city_name pay_us_city_names.city_name%TYPE;

760: l_applied_date DATE;
761: l_state_name pay_us_states.state_name%TYPE;
762: l_state_abbrev pay_us_states.state_abbrev%TYPE;
763: l_county_name pay_us_counties.county_name%TYPE;
764: l_city_name pay_us_city_names.city_name%TYPE;
765: l_old_juri_code pay_us_geo_update.old_juri_code%TYPE;
766: l_new_juri_code pay_us_geo_update.new_juri_code%TYPE;
767: l_full_name per_all_people_f.full_name%TYPE;
768: l_assignment_id pay_us_geo_update.assignment_id%TYPE;