APPS.PAY_US_ARCHIVE dependencies on PAY_US_COUNTY_SCHOOL_DSTS

Line 2992: l_cnt_sd_name pay_us_county_school_dsts.school_dst_name%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);
2996: l_city_code varchar2(4);

Line 3753: from pay_us_county_school_dsts pcs

3749:
3750: if l_chk_cnt_sd_archive = 'N' then
3751: select school_dst_name
3752: into l_cnt_sd_name
3753: from pay_us_county_school_dsts pcs
3754: where pcs.state_code = substr(l_jurisdiction,1,2)
3755: and pcs.county_code = l_county_code
3756: and school_dst_code = substr(l_jurisdiction,4,5);
3757: