APPS.PAY_US_SOE_BALANCES_PKG dependencies on PAY_US_SCHOOL_DSTS

Line 52: by the view PAY_US_SCHOOL_DSTS to handle

48: state EIC balances. Added code to
49: return STEIC balance as the fed
50: procedure does.
51: 04-FEB-2004 ardsouza 115.9 3412605 Replaced table PAY_US_CITY_SCHOOL_DSTS
52: by the view PAY_US_SCHOOL_DSTS to handle
53: county level school districts of Kentucky.
54: 26-FEB-2004 sdahiya 115.10 3464757 Modified cursor c_get_max_action_id
55: to use nvl(date_earned, effective_date)
56: instead of effective_date. Created a

Line 2137: l_school_code pay_us_school_dsts.school_dst_code%type;

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;
2140: l_juris_code pay_us_state_taxes_v.jurisdiction_code%type;
2141:

Line 2138: l_school_name pay_us_school_dsts.school_dst_name%type;

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;
2140: l_juris_code pay_us_state_taxes_v.jurisdiction_code%type;
2141:
2142: l_count number;

Line 2591: from pay_us_school_dsts --Bug 3412605

2587: -- Bug 3250653
2588: ELSIF local_tab(i).tax_type = 'SCHOOL' THEN
2589: hr_utility.set_location(l_package||l_procedure,240);
2590: select distinct school_dst_name into l_school_name
2591: from pay_us_school_dsts --Bug 3412605
2592: where school_dst_code = substr(local_tab(i).juris_code,4,5)
2593: and state_code = substr(local_tab(i).juris_code,1,2);
2594:
2595: l_school_code :=substr(local_tab(i).juris_code,4,5);