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_ES_SS_REP_ARCHIVE_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 279: ,hr_organization_information hoi

275: ,hoi.org_information1 Registered_Name
276: ,hoi.organization_id Legal_emp_org_id
277: /* Reserved, Seg. Hdr, Start and End date are defaulted */
278: FROM hr_all_organization_units hou
279: ,hr_organization_information hoi
280: ,hr_locations_all hloc
281: WHERE hou.business_group_id = c_business_group_id
282: AND hoi.organization_id = hou.organization_id
283: AND hoi.org_information_context = 'ES_STATUTORY_INFO'

Line 431: ,hr_organization_information wcr

427: SELECT paf.assignment_id assignment_id,
428: leg.organization_id legal_employer
429: FROM per_all_assignments_f paf
430: ,hr_soft_coding_keyflex sck
431: ,hr_organization_information wcr
432: ,hr_organization_information leg
433: WHERE paf.effective_start_date = (SELECT max (paf1.effective_start_date)
434: FROM per_all_assignments_f paf1
435: WHERE paf.assignment_id = paf1.assignment_id

Line 432: ,hr_organization_information leg

428: leg.organization_id legal_employer
429: FROM per_all_assignments_f paf
430: ,hr_soft_coding_keyflex sck
431: ,hr_organization_information wcr
432: ,hr_organization_information leg
433: WHERE paf.effective_start_date = (SELECT max (paf1.effective_start_date)
434: FROM per_all_assignments_f paf1
435: WHERE paf.assignment_id = paf1.assignment_id
436: AND paf1.effective_start_date <= p_reporting_date)