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_ESTABLISHMENTS_V

Line 95: FROM hr_establishments_v est,

91: SELECT 'TRANSFER_TAX_UNIT_ID=P',
92: htuv.tax_unit_id,
93: 'TRANSFER_ESTABLISHMENT_ID1=P',
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

Line 161: hr_establishments_v est ,

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 ,
165: pay_state_rules psr2

Line 432: hr_establishments_v hev,

428: cursor S_VETC_ASG_COUNT is
429: SELECT 'TRANSFER_COUNT_ASSIGNMENTS=P',
430: count(ass.assignment_id)
431: FROM per_assignments_f ass,
432: hr_establishments_v hev,
433: hr_locations hl,
434: pay_state_rules psr,
435: hr_organization_information hoi1,
436: hr_soft_coding_keyflex scf,