APPS.PAY_US_ARCHIVE dependencies on PAY_US_COUNTIES

Line 2990: l_county_name pay_us_counties.county_name%type;

2986: l_city_uei ff_user_entities.user_entity_id%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;

Line 3573: from pay_us_counties puc

3569: hr_utility.trace('Getting County Name from DB');
3570:
3571: select county_name
3572: into l_county_name
3573: from pay_us_counties puc
3574: where puc.state_code = substr(l_jurisdiction,1,2)
3575: and puc.county_code = substr(l_jurisdiction,4,3);
3576:
3577: l_jd_name_done_tab(l_jd_index).jd_name := l_county_name;