eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_GET_TAX_EXISTS_PKG dependencies on PAY_US_CITY_TAX_INFO_F

Line 1600: FROM pay_us_city_tax_info_f CITYTAX,

1596: -- or Not
1597: --
1598: SELECT CITYTAX.city_tax
1599: INTO l_city_rs_exists
1600: FROM pay_us_city_tax_info_f CITYTAX,
1601: fnd_sessions SES
1602: WHERE CITYTAX.JURISDICTION_CODE = p_juri_code
1603: AND SES.session_id = USERENV('SESSIONID')
1604: AND SES.effective_date BETWEEN

Line 1782: FROM pay_us_city_tax_info_f CITYTAX,

1778: BEGIN
1779: /*{*/
1780: SELECT CITYTAX.head_tax
1781: INTO l_ht_wk_exists
1782: FROM pay_us_city_tax_info_f CITYTAX,
1783: fnd_sessions SES
1784: WHERE CITYTAX.JURISDICTION_CODE = p_juri_code
1785: AND SES.session_id = USERENV('SESSIONID')
1786: AND SES.effective_date BETWEEN

Line 1857: FROM pay_us_city_tax_info_f CITYTAX,

1853: BEGIN
1854: /*{*/
1855: SELECT CITYTAX.city_tax
1856: INTO l_city_wk_exists
1857: FROM pay_us_city_tax_info_f CITYTAX,
1858: fnd_sessions SES
1859: WHERE CITYTAX.JURISDICTION_CODE = p_juri_code
1860: AND SES.session_id = USERENV('SESSIONID')
1861: AND SES.effective_date BETWEEN

Line 2192: FROM pay_us_city_tax_info_f

2188: effective_start_date AND effective_end_date;
2189:
2190: CURSOR city_exists IS
2191: SELECT city_tax
2192: FROM pay_us_city_tax_info_f
2193: WHERE jurisdiction_code = p_juri_code
2194: AND TO_DATE(l_date_earned, 'DD-MM-YYYY') BETWEEN
2195: effective_start_date AND effective_end_date;
2196: