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

Line 86: FROM hr_organization_information hoi

82: ,addr.loc_information14 c_building
83: ,addr.loc_information15 c_stairway
84: ,addr.loc_information16 c_floor
85: ,addr.loc_information17 c_door
86: FROM hr_organization_information hoi
87: ,hr_all_organization_units hou
88: ,hr_locations_all addr
89: ,hr_organization_information hoi1
90: WHERE hou.organization_id = c_business_group_id

Line 89: ,hr_organization_information hoi1

85: ,addr.loc_information17 c_door
86: FROM hr_organization_information hoi
87: ,hr_all_organization_units hou
88: ,hr_locations_all addr
89: ,hr_organization_information hoi1
90: WHERE hou.organization_id = c_business_group_id
91: AND hoi.organization_id = hou.organization_id
92: AND hoi.org_information_context = 'HU_COMPANY_INFORMATION_DETAILS'
93: AND hoi1.organization_id = hou.organization_id

Line 365: ,hr_organization_information hoi

361: ,per_periods_of_service ppf
362: ,per_all_assignments_f paa
363: ,pay_assignment_actions paas
364: ,hr_soft_coding_keyflex hr
365: ,hr_organization_information hoi
366: WHERE paas.assignment_action_id = p_assactid
367: AND paas.assignment_id = paa.assignment_id
368: AND pap.person_id = ppf.person_id
369: AND ppf.business_group_id = paa.business_group_id