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_LOCATIONS

Line 158: FROM hr_locations cloc ,

154: 'TRANSFER_EIN=P' ,
155: htuv.employer_identification_number ,
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 ,

Line 159: hr_locations eloc ,

155: htuv.employer_identification_number ,
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 ,

Line 297: hr_locations gloc

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
301: pay_magtape_generic.get_parameter_value('TRANSFER_GRE_STATE')

Line 392: hr_locations gloc

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
396: pay_magtape_generic.get_parameter_value('TRANSFER_GRE_STATE')

Line 433: hr_locations hl,

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,
437: per_jobs job