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_CAL_ENTRY_VALUES_LOAD_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 46: ,HR_ALL_ORGANIZATION_UNITS HOU_P

42: select POSE.ORG_STRUCTURE_ELEMENT_ID
43: from PER_ORGANIZATION_STRUCTURES POS
44: ,PER_ORG_STRUCTURE_VERSIONS POSV
45: ,PER_ORG_STRUCTURE_ELEMENTS POSE
46: ,HR_ALL_ORGANIZATION_UNITS HOU_P
47: ,HR_ALL_ORGANIZATION_UNITS HOU_C
48: where POS.NAME = X_ORG_HIER_NAME
49: and POS.ORGANIZATION_STRUCTURE_ID = POSV.ORGANIZATION_STRUCTURE_ID
50: and POSV.VERSION_NUMBER = X_ORG_HIER_VERSION

Line 47: ,HR_ALL_ORGANIZATION_UNITS HOU_C

43: from PER_ORGANIZATION_STRUCTURES POS
44: ,PER_ORG_STRUCTURE_VERSIONS POSV
45: ,PER_ORG_STRUCTURE_ELEMENTS POSE
46: ,HR_ALL_ORGANIZATION_UNITS HOU_P
47: ,HR_ALL_ORGANIZATION_UNITS HOU_C
48: where POS.NAME = X_ORG_HIER_NAME
49: and POS.ORGANIZATION_STRUCTURE_ID = POSV.ORGANIZATION_STRUCTURE_ID
50: and POSV.VERSION_NUMBER = X_ORG_HIER_VERSION
51: and POSV.ORG_STRUCTURE_VERSION_ID = POSE.ORG_STRUCTURE_VERSION_ID

Line 59: from HR_ALL_ORGANIZATION_UNITS HOU

55: and HOU_C.NAME = X_ORG_HIER_ELEMENT_CHILD;
56:
57: cursor CSR_ORG_HIER_NODE is
58: select HOU.ORGANIZATION_ID
59: from HR_ALL_ORGANIZATION_UNITS HOU
60: where HOU.NAME = X_ORG_HIER_NODE_NAME;
61:
62: begin
63: