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.HR_RU_ASG_HOOK dependencies on HR_ALL_ORGANIZATION_UNITS_TL

Line 70: from HR_ALL_ORGANIZATION_UNITS hou, HR_ALL_ORGANIZATION_UNITS_TL hout, HR_ORGANIZATION_INFORMATION hoi

66: IF p_segment1 <> hr_api.g_varchar2 THEN
67: BEGIN
68: select distinct hou.organization_id
69: INTO l_org_id
70: from HR_ALL_ORGANIZATION_UNITS hou, HR_ALL_ORGANIZATION_UNITS_TL hout, HR_ORGANIZATION_INFORMATION hoi
71: where hou.organization_id = hoi.organization_id
72: AND hou.organization_id = hout.organization_id
73: AND hou.organization_id = to_number(p_segment1)
74: AND hoi.org_information_context = 'CLASS'

Line 245: from HR_ALL_ORGANIZATION_UNITS hou, HR_ALL_ORGANIZATION_UNITS_TL hout, HR_ORGANIZATION_INFORMATION hoi

241: IF p_scl_segment1 IS NOT NULL THEN
242: BEGIN
243: select distinct hou.organization_id
244: INTO l_org_id
245: from HR_ALL_ORGANIZATION_UNITS hou, HR_ALL_ORGANIZATION_UNITS_TL hout, HR_ORGANIZATION_INFORMATION hoi
246: where hou.organization_id = hoi.organization_id
247: AND hou.organization_id = hout.organization_id
248: AND hou.organization_id = to_number(p_scl_segment1)
249: AND hoi.org_information_context = 'CLASS'