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.OKC_CONTEXT dependencies on HR_ALL_ORGANIZATION_UNITS

Line 21: FROM HR_ALL_ORGANIZATION_UNITS OU,

17: -- Bug Fix 5014701- Performance Re-Fix
18:
19: CURSOR c_bus_grp(p_id IN NUMBER) IS
20: SELECT business_group_id
21: FROM HR_ALL_ORGANIZATION_UNITS OU,
22: HR_ORGANIZATION_INFORMATION OI1,
23: HR_ORGANIZATION_INFORMATION OI2
24: WHERE OU.ORGANIZATION_ID = p_id
25: AND OI1.ORG_INFORMATION1 = 'OPERATING_UNIT'

Line 118: FROM HR_ALL_ORGANIZATION_UNITS OU

114: -- Bug Fix 5014701- Performance Fix
115:
116: CURSOR c_bus_grp(p_id IN NUMBER) IS
117: SELECT business_group_id
118: FROM HR_ALL_ORGANIZATION_UNITS OU
119: WHERE OU.ORGANIZATION_ID = p_id;
120:
121: /**
122: CURSOR c_bus_grp(p_id IN NUMBER) IS