APPS.PAY_GET_TAX_EXISTS_PKG dependencies on PAY_US_COUNTY_TAX_INFO_F

Line 448: FROM pay_us_county_tax_info_f COUNTYTAX

444: /*{*/
445:
446: SELECT COUNTYTAX.county_tax
447: INTO l_county_tax_exists
448: FROM pay_us_county_tax_info_f COUNTYTAX
449: WHERE COUNTYTAX.JURISDICTION_CODE = SUBSTR(p_juri_code, 1, 6) || '-0000'
450: AND TO_DATE(l_date_earned, 'dd-mm-yyyy') BETWEEN
451: COUNTYTAX.effective_start_date AND COUNTYTAX.effective_end_date;
452:

Line 2202: FROM pay_us_county_tax_info_f

2198: effective_start_date AND effective_end_date;
2199:
2200: CURSOR county_exists IS
2201: SELECT county_tax
2202: FROM pay_us_county_tax_info_f
2203: WHERE jurisdiction_code = substr(p_juri_code, 1, 6) || '-0000'
2204: AND to_date(l_date_earned, 'DD-MM-YYYY') BETWEEN
2205: effective_start_date AND effective_end_date;
2206: