APPS.PAY_US_ARCHIVE dependencies on PAY_US_COUNTY_SCHOOL_DSTS

Line 3564: l_cnt_sd_name pay_us_county_school_dsts.school_dst_name%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;
3567: l_county_code varchar2(3);
3568: l_city_code varchar2(4);

Line 4385: from pay_us_county_school_dsts pcs

4381:
4382: if l_chk_cnt_sd_archive = 'N' then
4383: select school_dst_name
4384: into l_cnt_sd_name
4385: from pay_us_county_school_dsts pcs
4386: where pcs.state_code = substr(l_jurisdiction,1,2)
4387: and pcs.county_code = l_county_code
4388: and school_dst_code = substr(l_jurisdiction,4,5);
4389: