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 1603: FROM pay_us_city_tax_info_f CITYTAX,

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

Line 1785: FROM pay_us_city_tax_info_f CITYTAX,

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

Line 1860: FROM pay_us_city_tax_info_f CITYTAX,

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

Line 2195: FROM pay_us_city_tax_info_f

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