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.GHR_GHRCPDFO_XMLP_PKG dependencies on PER_ORG_STRUCTURE_ELEMENTS

Line 33: PER_ORG_STRUCTURE_ELEMENTS ELE

29: 0 LVL,
30: ORGANIZATION_ID_PARENT ID,
31: ORG_STRUCTURE_VERSION_ID
32: FROM
33: PER_ORG_STRUCTURE_ELEMENTS ELE
34: WHERE ELE.ORGANIZATION_ID_PARENT NOT IN (
35: SELECT
36: ORGANIZATION_ID_CHILD
37: FROM

Line 38: PER_ORG_STRUCTURE_ELEMENTS ELE,

34: WHERE ELE.ORGANIZATION_ID_PARENT NOT IN (
35: SELECT
36: ORGANIZATION_ID_CHILD
37: FROM
38: PER_ORG_STRUCTURE_ELEMENTS ELE,
39: PER_ORG_STRUCTURE_VERSIONS VER
40: WHERE VER.ORGANIZATION_STRUCTURE_ID = P_ORGANIZATION_HIERARCHY
41: AND VER.ORG_STRUCTURE_VERSION_ID = ELE.ORG_STRUCTURE_VERSION_ID
42: AND VER.ORG_STRUCTURE_VERSION_ID = P_HIERARCHY_VERSION )

Line 135: PER_ORG_STRUCTURE_ELEMENTS A,

131: ,179
132: ,' ') TITLE,
133: PPDK.SEGMENT4 AGENCY_SUBELEMENT
134: FROM
135: PER_ORG_STRUCTURE_ELEMENTS A,
136: PER_ORG_STRUCTURE_VERSIONS B,
137: HR_ORGANIZATION_INFORMATION OEI,
138: HR_ORGANIZATION_UNITS HRU,
139: PER_POSITION_EXTRA_INFO PPEI,

Line 156: PER_ORG_STRUCTURE_ELEMENTS

152: AND A.ORG_STRUCTURE_ELEMENT_ID IN (
153: SELECT
154: ORG_STRUCTURE_ELEMENT_ID
155: FROM
156: PER_ORG_STRUCTURE_ELEMENTS
157: START WITH ORGANIZATION_ID_PARENT = P_PARENT_ID
158: CONNECT BY PRIOR ORGANIZATION_ID_CHILD = ORGANIZATION_ID_PARENT )
159: AND OEI.ORGANIZATION_ID = A.ORGANIZATION_ID_CHILD
160: AND OEI.ORG_INFORMATION_CONTEXT = 'GHR_US_ORG_REPORTING_INFO'