APPS.PAY_US_ARCHIVE dependencies on PAY_US_COUNTIES

Line 3562: l_county_name pay_us_counties.county_name%type;

3558: l_city_uei ff_user_entities.user_entity_id%type;
3559: l_county_sd_uei ff_user_entities.user_entity_id%type;
3560: l_city_sd_uei ff_user_entities.user_entity_id%type;
3561: l_state_abbrev pay_us_states.state_abbrev%type;
3562: l_county_name pay_us_counties.county_name%type;
3563: l_city_name pay_us_city_names.city_name%type;
3564: l_cnt_sd_name pay_us_county_school_dsts.school_dst_name%type;
3565: l_cty_sd_name pay_us_city_school_dsts.school_dst_name%type;
3566: l_step number := 0;

Line 4205: from pay_us_counties puc

4201: hr_utility.trace('Getting County Name from DB');
4202:
4203: select county_name
4204: into l_county_name
4205: from pay_us_counties puc
4206: where puc.state_code = substr(l_jurisdiction,1,2)
4207: and puc.county_code = substr(l_jurisdiction,4,3);
4208:
4209: l_jd_name_done_tab(l_jd_index).jd_name := l_county_name;