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_PERUSE1L_XMLP_PKG dependencies on PER_GEN_HIERARCHY_NODES

Line 44: PER_GEN_HIERARCHY_NODES PGN

40: INTO C_HIERARCHY_NAME,C_HIERARCHY_VERSION_NUM,C_PARENT_ORG_ID,C_PARENT_NODE_ID
41: FROM
42: PER_GEN_HIERARCHY PGH,
43: PER_GEN_HIERARCHY_VERSIONS PGV,
44: PER_GEN_HIERARCHY_NODES PGN
45: WHERE PGH.HIERARCHY_ID = P_HIERARCHY_ID
46: AND PGH.HIERARCHY_ID = PGV.HIERARCHY_ID
47: AND PGV.HIERARCHY_VERSION_ID = P_HIERARCHY_VERSION_ID
48: AND PGN.HIERARCHY_VERSION_ID = PGV.HIERARCHY_VERSION_ID

Line 54: PER_GEN_HIERARCHY_NODES PGHN

50: SELECT
51: COUNT(PGHN.HIERARCHY_NODE_ID)
52: INTO C_NO_OF_ESTABLISHMENTS
53: FROM
54: PER_GEN_HIERARCHY_NODES PGHN
55: WHERE PGHN.HIERARCHY_VERSION_ID = P_HIERARCHY_VERSION_ID
56: AND PGHN.NODE_TYPE = 'EST';
57: OPEN C_DEFAULTS;
58: FETCH C_DEFAULTS

Line 128: PER_GEN_HIERARCHY_NODES PGHN

124: NVL(HLEI1.LEI_INFORMATION8
125: ,DEFAULT_ACTIVITIES_LINE4)
126: FROM
127: HR_LOCATION_EXTRA_INFO HLEI1,
128: PER_GEN_HIERARCHY_NODES PGHN
129: WHERE ( HLEI1.INFORMATION_TYPE = 'EEO-1 Specific Information'
130: AND HLEI1.LEI_INFORMATION_CATEGORY = 'EEO-1 Specific Information' )
131: AND HLEI1.LOCATION_ID = PGHN.ENTITY_ID
132: AND PGHN.PARENT_HIERARCHY_NODE_ID = C_PARENT_NODE_ID

Line 204: PER_GEN_HIERARCHY_NODES PGN

200: SELECT
201: DISTINCT
202: PGN.ENTITY_ID
203: FROM
204: PER_GEN_HIERARCHY_NODES PGN
205: WHERE PGN.HIERARCHY_VERSION_ID = P_HIERARCHY_VERSION_ID
206: AND ( PGN.HIERARCHY_NODE_ID = EST_NODE_ID
207: OR PGN.PARENT_HIERARCHY_NODE_ID = EST_NODE_ID )
208: AND PGN.NODE_TYPE in ( 'EST' , 'LOC' ) )

Line 288: PER_GEN_HIERARCHY_NODES PGN

284: SELECT
285: DISTINCT
286: PGN.ENTITY_ID
287: FROM
288: PER_GEN_HIERARCHY_NODES PGN
289: WHERE PGN.HIERARCHY_VERSION_ID = P_HIERARCHY_VERSION_ID
290: AND ( PGN.HIERARCHY_NODE_ID = EST_NODE_ID
291: OR PGN.PARENT_HIERARCHY_NODE_ID = EST_NODE_ID )
292: AND PGN.NODE_TYPE in ( 'EST' , 'LOC' ) )

Line 342: PER_GEN_HIERARCHY_NODES PGN

338: SELECT
339: DISTINCT
340: PGN.ENTITY_ID
341: FROM
342: PER_GEN_HIERARCHY_NODES PGN
343: WHERE PGN.HIERARCHY_VERSION_ID = P_HIERARCHY_VERSION_ID
344: AND ( PGN.HIERARCHY_NODE_ID = EST_NODE_ID
345: OR PGN.PARENT_HIERARCHY_NODE_ID = EST_NODE_ID )
346: AND PGN.NODE_TYPE in ( 'EST' , 'LOC' ) );