DBA Data[Home] [Help]

APPS.PAY_US_ARCHIVE dependencies on PAY_US_CITY_SCHOOL_DSTS

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

Line 3834: from pay_us_city_school_dsts pcs

3830: if l_chk_city_sd_archive = 'N' then
3831:
3832: select school_dst_name
3833: into l_cty_sd_name
3834: from pay_us_city_school_dsts pcs
3835: where pcs.state_code = substr(l_jurisdiction,1,2)
3836: and pcs.county_code = l_county_code
3837: and pcs.city_code = l_city_code
3838: and school_dst_code = substr(l_jurisdiction,4,5);