APPS.PER_PERUSE1L_XMLP_PKG dependencies on PER_GEN_HIERARCHY

Line 42: PER_GEN_HIERARCHY PGH,

38: PGN.ENTITY_ID,
39: PGN.HIERARCHY_NODE_ID
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

Line 43: PER_GEN_HIERARCHY_VERSIONS PGV,

39: PGN.HIERARCHY_NODE_ID
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

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 235: PER_GEN_HIERARCHY_NODES PGN

231: AND ASS.LOCATION_ID = HL.LOCATION_ID
232: AND EXISTS (
233: SELECT 1
234: FROM
235: PER_GEN_HIERARCHY_NODES PGN
236: WHERE PGN.HIERARCHY_VERSION_ID = P_HIERARCHY_VERSION_ID
237: AND ( PGN.HIERARCHY_NODE_ID = EST_NODE_ID
238: OR PGN.PARENT_HIERARCHY_NODE_ID = EST_NODE_ID )
239: AND PGN.NODE_TYPE in ( 'EST' , 'LOC' )

Line 248: PER_GEN_HIERARCHY_NODES PGN

244: SELECT
245: DISTINCT
246: PGN.ENTITY_ID
247: FROM
248: PER_GEN_HIERARCHY_NODES PGN
249: WHERE PGN.HIERARCHY_VERSION_ID = P_HIERARCHY_VERSION_ID
250: AND ( PGN.HIERARCHY_NODE_ID = EST_NODE_ID
251: OR PGN.PARENT_HIERARCHY_NODE_ID = EST_NODE_ID )
252: AND PGN.NODE_TYPE in ( 'EST' , 'LOC' ) )

Line 376: PER_GEN_HIERARCHY_NODES PGN

372: */
373: AND EXISTS (
374: SELECT 1
375: FROM
376: PER_GEN_HIERARCHY_NODES PGN
377: WHERE PGN.HIERARCHY_VERSION_ID = P_HIERARCHY_VERSION_ID
378: AND ( PGN.HIERARCHY_NODE_ID = EST_NODE_ID
379: OR PGN.PARENT_HIERARCHY_NODE_ID = EST_NODE_ID )
380: AND PGN.NODE_TYPE in ( 'EST' , 'LOC' )

Line 389: PER_GEN_HIERARCHY_NODES PGN

385: SELECT
386: DISTINCT
387: PGN.ENTITY_ID
388: FROM
389: PER_GEN_HIERARCHY_NODES PGN
390: WHERE PGN.HIERARCHY_VERSION_ID = P_HIERARCHY_VERSION_ID
391: AND ( PGN.HIERARCHY_NODE_ID = EST_NODE_ID
392: OR PGN.PARENT_HIERARCHY_NODE_ID = EST_NODE_ID )
393: AND PGN.NODE_TYPE in ( 'EST' , 'LOC' ) )

Line 481: PER_GEN_HIERARCHY_NODES PGN

477: AND HEADQUARTERS = 'N'
478: AND EXISTS (
479: SELECT 1
480: FROM
481: PER_GEN_HIERARCHY_NODES PGN
482: WHERE PGN.HIERARCHY_VERSION_ID = P_HIERARCHY_VERSION_ID
483: AND ( PGN.HIERARCHY_NODE_ID = EST_NODE_ID
484: OR PGN.PARENT_HIERARCHY_NODE_ID = EST_NODE_ID )
485: AND PGN.NODE_TYPE in ( 'EST' , 'LOC' )

Line 494: PER_GEN_HIERARCHY_NODES PGN

490: SELECT
491: DISTINCT
492: PGN.ENTITY_ID
493: FROM
494: PER_GEN_HIERARCHY_NODES PGN
495: WHERE PGN.HIERARCHY_VERSION_ID = P_HIERARCHY_VERSION_ID
496: AND ( PGN.HIERARCHY_NODE_ID = EST_NODE_ID
497: OR PGN.PARENT_HIERARCHY_NODE_ID = EST_NODE_ID )
498: AND PGN.NODE_TYPE in ( 'EST' , 'LOC' ) )