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_GEOCODE_ENGINE_PKG dependencies on PAY_US_STATES

Line 61: pay_us_states pus

57: select count (tr.assignment_id)
58: from pay_us_modified_geocodes mg,
59: pay_us_emp_city_tax_rules_f tr,
60: per_all_assignments_f paf,
61: pay_us_states pus
62: where mg.patch_name = p_patch_name
63: and mg.state_code = pus.state_code
64: and mg.state_code = tr.state_code
65: and mg.county_code = tr.county_code

Line 90: pay_us_states pus

86: is
87: select count(person_id)
88: from per_addresses pa,
89: pay_us_modified_geocodes pmod,
90: pay_us_states pus
91: where pmod.state_code = pus.state_code
92: and (( pa.country = decode(pus.state_code,70,'CA','US')
93: and pus.state_abbrev = pa.region_2
94: and pmod.city_name = pa.region_1 )

Line 106: pay_us_states pus

102: is
103: select count(location_id)
104: from hr_locations_all hl,
105: pay_us_modified_geocodes pmod,
106: pay_us_states pus
107: where pmod.state_code = pus.state_code
108: and (( hl.country = decode(pus.state_code,70,'CA','US')
109: and pus.state_abbrev = hl.region_2
110: and pmod.city_name = hl.region_1 )