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

Line 999: --,pay_us_city_tax_info_f puctif

995: ff_contexts fc1 , --for city context
996: ff_archive_items fai1, -- city
997: ff_archive_item_contexts faic1, -- city_context
998: ff_database_items fdi1 --database_items for City_withheld
999: --,pay_us_city_tax_info_f puctif
1000: WHERE
1001: ppa1.payroll_action_id = p_pactid
1002: and ppa.business_group_id+0 = ppa1.business_group_id
1003: and ppa1.effective_date = ppa.effective_date

Line 1021: and exists ( select 'x' from pay_us_city_tax_info_f puctif

1017: -- Commented for to generalise locality or ageny code
1018: --and (puctif.city_information1 like 'RITA%'
1019: -- or puctif.city_information1 like 'CCCA%')
1020: --
1021: and exists ( select 'x' from pay_us_city_tax_info_f puctif
1022: where puctif.jurisdiction_code = ltrim(rtrim(faic1.context))
1023: and ltrim(rtrim(faic1.context)) like c_state_code||'%'
1024: and puctif.city_information1 like c_locality_code||'%'
1025: and puctif.effective_start_date < ppa.effective_date