APPS.PAY_GET_TAX_EXISTS_PKG dependencies on PAY_US_COUNTY_TAX_INFO_F

Line 445: FROM pay_us_county_tax_info_f COUNTYTAX

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

Line 2199: FROM pay_us_county_tax_info_f

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