APPS.PAY_US_EMP_TAX_RULES_PKG dependencies on PAY_US_COUNTY_SCHOOL_DSTS

Line 1257: FROM pay_us_county_school_dsts

1253: and upper(meaning) = 'SINGLE';
1254: --
1255: CURSOR csr_get_county_sd IS
1256: SELECT school_dst_code
1257: FROM pay_us_county_school_dsts
1258: WHERE STATE_CODE = fnd_number.canonical_to_number(substr(P_locality_code,1,2))
1259: AND COUNTY_CODE = fnd_number.canonical_to_number(substr(P_locality_code,4,3))
1260: AND p_resident_flag = 'Y'
1261: ORDER BY fnd_number.canonical_to_number(school_dst_code);

Line 2135: FROM pay_us_county_school_dsts

2131:
2132: /* Cursor to get the the county School district */
2133: CURSOR csr_get_county_sd(Jurisdiction varchar2) IS
2134: SELECT school_dst_code
2135: FROM pay_us_county_school_dsts
2136: WHERE STATE_CODE = fnd_number.canonical_to_number(substr(Jurisdiction,1,2))
2137: AND COUNTY_CODE = fnd_number.canonical_to_number(substr(Jurisdiction,4,3))
2138: ORDER BY TO_NUMBER(school_dst_code);
2139: