APPS.PAY_US_SOE_BALANCES_PKG dependencies on PAY_US_COUNTIES

Line 2134: l_county_code pay_us_counties.county_code%type;

2130: p_dedn_tab out nocopy dedn)
2131: IS
2132:
2133: l_county_state_code varchar2(2);
2134: l_county_code pay_us_counties.county_code%type;
2135: l_county_name pay_us_counties.county_name%type;
2136:
2137: l_school_code pay_us_school_dsts.school_dst_code%type;
2138: l_school_name pay_us_school_dsts.school_dst_name%type;

Line 2135: l_county_name pay_us_counties.county_name%type;

2131: IS
2132:
2133: l_county_state_code varchar2(2);
2134: l_county_code pay_us_counties.county_code%type;
2135: l_county_name pay_us_counties.county_name%type;
2136:
2137: l_school_code pay_us_school_dsts.school_dst_code%type;
2138: l_school_name pay_us_school_dsts.school_dst_name%type;
2139: l_school_jd pay_us_local_taxes_v.jurisdiction_code%type;

Line 2580: from pay_us_counties

2576:
2577: ELSIF local_tab(i).tax_type = 'COUNTY' THEN
2578: hr_utility.set_location(l_package||l_procedure,230);
2579: select county_name into l_county_name
2580: from pay_us_counties
2581: where county_code = substr(local_tab(i).juris_code,4,3)
2582: and state_code = substr(local_tab(i).juris_code,1,2);
2583:
2584: local_tab(i).rep_name := REPLACE(local_tab(i).rep_name, 'EE ', '');