APPS.PAY_US_USER_CITY_UPGRADE_PKG dependencies on PAY_US_STATES

Line 648: pay_us_states pus,

644: pugu.old_juri_code,
645: pugu.new_juri_code
646: FROM pay_us_geo_update pugu,
647: pay_patch_status pps,
648: pay_us_states pus,
649: pay_us_counties puc
650: WHERE pps.patch_name = 'USER_CITY_UPGRADE'
651: AND pps.phase = 'TO_BE_UPDATED'
652: AND pps.process_type = 'USER_CITY_UPGRADE'

Line 761: l_state_name pay_us_states.state_name%TYPE;

757: = DECODE(p_status,'ALL',DECODE(pugu.status,'C','C','E'),p_status));
758:
759: l_id pay_patch_status.id%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;

Line 762: l_state_abbrev pay_us_states.state_abbrev%TYPE;

758:
759: l_id pay_patch_status.id%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;