APPS.PAY_US_ARCHIVE dependencies on PAY_US_CITY_SCHOOL_DSTS

Line 3565: l_cty_sd_name pay_us_city_school_dsts.school_dst_name%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);
3569: l_person_id per_people_f.person_id%type;

Line 4466: from pay_us_city_school_dsts pcs

4462: if l_chk_city_sd_archive = 'N' then
4463:
4464: select school_dst_name
4465: into l_cty_sd_name
4466: from pay_us_city_school_dsts pcs
4467: where pcs.state_code = substr(l_jurisdiction,1,2)
4468: and pcs.county_code = l_county_code
4469: and pcs.city_code = l_city_code
4470: and school_dst_code = substr(l_jurisdiction,4,5);