APPS.PAY_US_ARCHIVE dependencies on PAY_US_CITY_NAMES

Line 2991: l_city_name pay_us_city_names.city_name%type;

2987: l_county_sd_uei ff_user_entities.user_entity_id%type;
2988: l_city_sd_uei ff_user_entities.user_entity_id%type;
2989: l_state_abbrev pay_us_states.state_abbrev%type;
2990: l_county_name pay_us_counties.county_name%type;
2991: l_city_name pay_us_city_names.city_name%type;
2992: l_cnt_sd_name pay_us_county_school_dsts.school_dst_name%type;
2993: l_cty_sd_name pay_us_city_school_dsts.school_dst_name%type;
2994: l_step number := 0;
2995: l_county_code varchar2(3);

Line 3468: from pay_us_city_names pcn

3464: hr_utility.trace('Getting City Name from DB');
3465:
3466: select city_name
3467: into l_city_name
3468: from pay_us_city_names pcn
3469: where pcn.state_code = substr(l_jurisdiction,1,2)
3470: and pcn.county_code = substr(l_jurisdiction,4,3)
3471: and pcn.city_code = substr(l_jurisdiction,8,4)
3472: and pcn.primary_flag = 'Y';