APPS.PER_PERUSEO1_XMLP_PKG dependencies on PER_GEN_HIERARCHY_NODES

Line 43: PER_GEN_HIERARCHY_NODES PGN

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

Line 53: PER_GEN_HIERARCHY_NODES PGHN

49: SELECT
50: COUNT('h_node')
51: INTO C_NO_OF_ESTABLISHMENTS
52: FROM
53: PER_GEN_HIERARCHY_NODES PGHN
54: WHERE PGHN.HIERARCHY_VERSION_ID = P_HIERARCHY_VERSION_ID
55: AND PGHN.NODE_TYPE = 'EST';
56: /*SRW.MESSAGE('10'
57: ,'number of establishments: ' || C_NO_OF_ESTABLISHMENTS)*/NULL;

Line 97: PER_GEN_HIERARCHY_NODES PGN,

93: INTO L_DUMMY
94: FROM
95: HR_LOCATION_EXTRA_INFO HLEI1,
96: HR_LOCATION_EXTRA_INFO HLEI2,
97: PER_GEN_HIERARCHY_NODES PGN,
98: HR_LOCATIONS_ALL ELOC
99: WHERE PGN.HIERARCHY_VERSION_ID = P_HIERARCHY_VERSION_ID
100: AND PGN.NODE_TYPE = 'EST'
101: AND ELOC.LOCATION_ID = PGN.ENTITY_ID

Line 125: PER_GEN_HIERARCHY_NODES PGN,

121: ELOC.LOCATION_CODE
122: INTO L_LOCATION_ID,L_LOCATION_CODE
123: FROM
124: HR_LOCATION_EXTRA_INFO HLEI1,
125: PER_GEN_HIERARCHY_NODES PGN,
126: HR_LOCATIONS_ALL ELOC
127: WHERE PGN.HIERARCHY_VERSION_ID = P_HIERARCHY_VERSION_ID
128: AND PGN.NODE_TYPE = 'EST'
129: AND ELOC.LOCATION_ID = PGN.ENTITY_ID

Line 165: PER_GEN_HIERARCHY_NODES PGN,

161: ELOC.LOCATION_CODE
162: INTO L_DUMMY,L_LOCATION_ID,L_LOCATION_CODE
163: FROM
164: HR_LOCATION_EXTRA_INFO HLEI1,
165: PER_GEN_HIERARCHY_NODES PGN,
166: HR_LOCATIONS_ALL ELOC
167: WHERE PGN.HIERARCHY_VERSION_ID = P_HIERARCHY_VERSION_ID
168: AND PGN.NODE_TYPE = 'EST'
169: AND ELOC.LOCATION_ID = PGN.ENTITY_ID

Line 371: PER_GEN_HIERARCHY_NODES PGN

367: SELECT
368: DISTINCT
369: PGN.ENTITY_ID
370: FROM
371: PER_GEN_HIERARCHY_NODES PGN
372: WHERE PGN.HIERARCHY_VERSION_ID = P_HIERARCHY_VERSION_ID
373: AND ( PGN.HIERARCHY_NODE_ID = C_TOT_EMPSFORMULA.EST_NODE_ID
374: OR PGN.PARENT_HIERARCHY_NODE_ID = C_TOT_EMPSFORMULA.EST_NODE_ID )
375: AND PGN.NODE_TYPE in ( 'EST' , 'LOC' ) );

Line 415: PER_GEN_HIERARCHY_NODES PGHN

411: NVL(HLEI.LEI_INFORMATION8
412: ,C_DEF_ACTIV_4)
413: FROM
414: HR_LOCATION_EXTRA_INFO HLEI,
415: PER_GEN_HIERARCHY_NODES PGHN
416: WHERE HLEI.INFORMATION_TYPE = 'EEO-1 Specific Information'
417: AND HLEI.LEI_INFORMATION_CATEGORY = 'EEO-1 Specific Information'
418: AND HLEI.LOCATION_ID = PGHN.ENTITY_ID
419: AND PGHN.PARENT_HIERARCHY_NODE_ID = C_PARENT_NODE_ID

Line 543: PER_GEN_HIERARCHY_NODES PGN

539: SELECT
540: DISTINCT
541: PGN.ENTITY_ID
542: FROM
543: PER_GEN_HIERARCHY_NODES PGN
544: WHERE ( PGN.HIERARCHY_NODE_ID = EST_NODE_ID
545: OR PGN.PARENT_HIERARCHY_NODE_ID = EST_NODE_ID )
546: AND PGN.HIERARCHY_VERSION_ID = P_HIERARCHY_VERSION_ID
547: AND PGN.NODE_TYPE in ( 'EST' , 'LOC' ) );

Line 575: PER_GEN_HIERARCHY_NODES PGN

571: SELECT
572: DISTINCT
573: PGN.ENTITY_ID
574: FROM
575: PER_GEN_HIERARCHY_NODES PGN
576: WHERE PGN.HIERARCHY_VERSION_ID = P_HIERARCHY_VERSION_ID
577: AND ( PGN.HIERARCHY_NODE_ID = EST_NODE_ID
578: OR PGN.PARENT_HIERARCHY_NODE_ID = EST_NODE_ID )
579: AND PGN.NODE_TYPE in ( 'EST' , 'LOC' ) );

Line 650: PER_GEN_HIERARCHY_NODES

646: SELECT
647: DISTINCT
648: ENTITY_ID
649: FROM
650: PER_GEN_HIERARCHY_NODES
651: WHERE HIERARCHY_VERSION_ID = P_HIERARCHY_VERSION_ID );
652: IF L_COUNT_EMPS >= 100 THEN
653: RETURN ('Y');
654: ELSE

Line 693: PER_GEN_HIERARCHY_NODES PGN,

689: ELOC.LOCATION_ID,
690: ELOC.LOCATION_CODE
691: INTO L_LOCATION_ID,L_LOCATION_CODE
692: FROM
693: PER_GEN_HIERARCHY_NODES PGN,
694: HR_LOCATIONS_ALL ELOC
695: WHERE ( HIERARCHY_NODE_ID = EST_NODE_ID
696: OR PARENT_HIERARCHY_NODE_ID = EST_NODE_ID )
697: AND HIERARCHY_VERSION_ID = P_HIERARCHY_VERSION_ID

Line 909: PER_GEN_HIERARCHY_NODES PGN

905: SELECT
906: DISTINCT
907: PGN.ENTITY_ID
908: FROM
909: PER_GEN_HIERARCHY_NODES PGN
910: WHERE PGN.HIERARCHY_VERSION_ID = P_HIERARCHY_VERSION_ID
911: AND ( PGN.HIERARCHY_NODE_ID = EST_NODE_ID
912: OR PGN.PARENT_HIERARCHY_NODE_ID = EST_NODE_ID )
913: AND PGN.NODE_TYPE in ( 'EST' , 'LOC' ) )