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.PER_US_VETC_TAP dependencies on HR_TAX_UNITS_V

Line 98: hr_tax_units_v htuv

94: est.establishment_id
95: FROM hr_establishments_v est,
96: hr_organization_units hou1,
97: hr_organization_units hou2,
98: hr_tax_units_v htuv
99: WHERE htuv.tax_unit_id(+) = hou1.organization_id
100: AND hou1.organization_id =
101: pay_magtape_generic.get_parameter_value('TRANSFER_ORG_ID')
102: AND est.establishment_id(+) = hou2.organization_id

Line 160: hr_tax_units_v htuv ,

156: 'TRANSFER_DUN=P' ,
157: htuv.dun_and_bradstreet_number
158: FROM hr_locations cloc ,
159: hr_locations eloc ,
160: hr_tax_units_v htuv ,
161: hr_establishments_v est ,
162: hr_organization_units hou1 ,
163: hr_organization_units hou2 ,
164: pay_state_rules psr1 ,

Line 296: FROM hr_tax_units_v htuv,

292: -- pay_magtape_generic.get_parameter_value('TRANSFER_TAX_UNIT_ID')
293: /* AND EXISTS
294: (
295: SELECT htuv.tax_unit_id
296: FROM hr_tax_units_v htuv,
297: hr_locations gloc
298: WHERE htuv.tax_unit_id = scf.segment1
299: AND htuv.location_id = gloc.location_id
300: AND gloc.region_2 = -- :gre_state

Line 391: FROM hr_tax_units_v htuv,

387: -- pay_magtape_generic.get_parameter_value('TRANSFER_TAX_UNIT_ID')
388: /* AND EXISTS
389: (
390: SELECT htuv.tax_unit_id
391: FROM hr_tax_units_v htuv,
392: hr_locations gloc
393: WHERE htuv.tax_unit_id = scf.segment1
394: AND htuv.location_id = gloc.location_id
395: AND gloc.region_2 = -- :gre_state