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_US_W2_GENERIC_EXTRACT dependencies on PAY_US_CITY_TAX_INFO_F

Line 1588: AND EXISTS ( SELECT 'x' from pay_us_city_tax_info_f puctif

1584: AND fai1.archive_item_id = faic1.archive_item_id
1585: AND ltrim(rtrim(faic1.context)) like c_state_code||'%'
1586: AND c_locality_code IS NULL
1587: AND rtrim(ltrim(fai1.value)) <> '0'
1588: AND EXISTS ( SELECT 'x' from pay_us_city_tax_info_f puctif
1589: WHERE puctif.jurisdiction_code = ltrim(rtrim(faic1.context))
1590: AND puctif.effective_start_date < ppa.effective_date
1591: AND puctif.effective_end_date >= ppa.effective_date
1592: )

Line 1613: AND EXISTS ( SELECT 'x' from pay_us_city_tax_info_f puctif

1609: AND substr(ltrim(rtrim(faic1.context)),1,2) = c_state_code
1610: AND substr(ltrim(rtrim(faic1.context)),8,4) = substr(c_locality_code,8,4)
1611: AND c_locality_code IS NOT NULL
1612: AND rtrim(ltrim(fai1.value)) <> '0'
1613: AND EXISTS ( SELECT 'x' from pay_us_city_tax_info_f puctif
1614: WHERE puctif.jurisdiction_code = ltrim(rtrim(faic1.context))
1615: AND puctif.effective_start_date < ppa.effective_date
1616: AND puctif.effective_end_date >= ppa.effective_date
1617: )

Line 1700: from pay_us_city_tax_info_f a,

1696: SELECT c.city_name city_name,
1697: n.county_name county_name,
1698: 'C' tax_type,
1699: a.city_information1 city_code
1700: from pay_us_city_tax_info_f a,
1701: pay_us_city_names c,
1702: pay_us_counties n
1703: where sysdate between a.effective_start_date and a.effective_end_date
1704: and a.jurisdiction_code = c_jurisdiction_code