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_ORGANIZATION_UNITS

Line 96: hr_organization_units hou1,

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
100: AND hou1.organization_id =

Line 97: hr_organization_units hou2,

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
100: AND hou1.organization_id =
101: pay_magtape_generic.get_parameter_value('TRANSFER_ORG_ID')

Line 162: hr_organization_units hou1 ,

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
166: WHERE htuv.tax_unit_id (+) = hou1.organization_id

Line 163: hr_organization_units hou2 ,

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
166: WHERE htuv.tax_unit_id (+) = hou1.organization_id
167: AND hou1.organization_id =