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_PERUSEO1_XMLP_PKG dependencies on PER_GEN_HIERARCHY

Line 182: PER_GEN_HIERARCHY PGH,

178: PGN.ENTITY_ID,
179: PGN.HIERARCHY_NODE_ID
180: INTO C_HIERARCHY_NAME,C_HIERARCHY_VERSION_NUM,C_PARENT_ORG_ID,C_PARENT_NODE_ID
181: FROM
182: PER_GEN_HIERARCHY PGH,
183: PER_GEN_HIERARCHY_VERSIONS PGV,
184: PER_GEN_HIERARCHY_NODES PGN
185: WHERE PGH.HIERARCHY_ID = P_HIERARCHY_ID
186: AND PGH.HIERARCHY_ID = PGV.HIERARCHY_ID

Line 183: PER_GEN_HIERARCHY_VERSIONS PGV,

179: PGN.HIERARCHY_NODE_ID
180: INTO C_HIERARCHY_NAME,C_HIERARCHY_VERSION_NUM,C_PARENT_ORG_ID,C_PARENT_NODE_ID
181: FROM
182: PER_GEN_HIERARCHY PGH,
183: PER_GEN_HIERARCHY_VERSIONS PGV,
184: PER_GEN_HIERARCHY_NODES PGN
185: WHERE PGH.HIERARCHY_ID = P_HIERARCHY_ID
186: AND PGH.HIERARCHY_ID = PGV.HIERARCHY_ID
187: AND PGV.HIERARCHY_VERSION_ID = P_HIERARCHY_VERSION_ID

Line 184: PER_GEN_HIERARCHY_NODES PGN

180: INTO C_HIERARCHY_NAME,C_HIERARCHY_VERSION_NUM,C_PARENT_ORG_ID,C_PARENT_NODE_ID
181: FROM
182: PER_GEN_HIERARCHY PGH,
183: PER_GEN_HIERARCHY_VERSIONS PGV,
184: PER_GEN_HIERARCHY_NODES PGN
185: WHERE PGH.HIERARCHY_ID = P_HIERARCHY_ID
186: AND PGH.HIERARCHY_ID = PGV.HIERARCHY_ID
187: AND PGV.HIERARCHY_VERSION_ID = P_HIERARCHY_VERSION_ID
188: AND PGN.HIERARCHY_VERSION_ID = PGV.HIERARCHY_VERSION_ID

Line 194: PER_GEN_HIERARCHY_NODES PGHN

190: SELECT
191: COUNT('h_node')
192: INTO C_NO_OF_ESTABLISHMENTS
193: FROM
194: PER_GEN_HIERARCHY_NODES PGHN
195: WHERE PGHN.HIERARCHY_VERSION_ID = P_HIERARCHY_VERSION_ID
196: AND PGHN.NODE_TYPE = 'EST';
197: /*SRW.MESSAGE('10'
198: ,'number of establishments: ' || C_NO_OF_ESTABLISHMENTS)*/NULL;

Line 238: PER_GEN_HIERARCHY_NODES PGN,

234: INTO L_DUMMY
235: FROM
236: HR_LOCATION_EXTRA_INFO HLEI1,
237: HR_LOCATION_EXTRA_INFO HLEI2,
238: PER_GEN_HIERARCHY_NODES PGN,
239: HR_LOCATIONS_ALL ELOC
240: WHERE PGN.HIERARCHY_VERSION_ID = P_HIERARCHY_VERSION_ID
241: AND PGN.NODE_TYPE = 'EST'
242: AND ELOC.LOCATION_ID = PGN.ENTITY_ID

Line 266: PER_GEN_HIERARCHY_NODES PGN,

262: ELOC.LOCATION_CODE
263: INTO L_LOCATION_ID,L_LOCATION_CODE
264: FROM
265: HR_LOCATION_EXTRA_INFO HLEI1,
266: PER_GEN_HIERARCHY_NODES PGN,
267: HR_LOCATIONS_ALL ELOC
268: WHERE PGN.HIERARCHY_VERSION_ID = P_HIERARCHY_VERSION_ID
269: AND PGN.NODE_TYPE = 'EST'
270: AND ELOC.LOCATION_ID = PGN.ENTITY_ID

Line 306: PER_GEN_HIERARCHY_NODES PGN,

302: ELOC.LOCATION_CODE
303: INTO L_DUMMY,L_LOCATION_ID,L_LOCATION_CODE
304: FROM
305: HR_LOCATION_EXTRA_INFO HLEI1,
306: PER_GEN_HIERARCHY_NODES PGN,
307: HR_LOCATIONS_ALL ELOC
308: WHERE PGN.HIERARCHY_VERSION_ID = P_HIERARCHY_VERSION_ID
309: AND PGN.NODE_TYPE = 'EST'
310: AND ELOC.LOCATION_ID = PGN.ENTITY_ID

Line 560: PER_GEN_HIERARCHY_NODES PGN

556: AND P_PAYROLL_PERIOD_DATE_END_T >= ASS.EFFECTIVE_START_DATE
557: AND EXISTS (
558: SELECT 1
559: FROM
560: PER_GEN_HIERARCHY_NODES PGN
561: WHERE PGN.HIERARCHY_VERSION_ID = P_HIERARCHY_VERSION_ID
562: AND ( PGN.HIERARCHY_NODE_ID = C_TOT_EMPSFORMULA.EST_NODE_ID
563: OR PGN.PARENT_HIERARCHY_NODE_ID = C_TOT_EMPSFORMULA.EST_NODE_ID )
564: AND PGN.NODE_TYPE in ( 'EST' , 'LOC' )

Line 573: PER_GEN_HIERARCHY_NODES PGN

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

Line 648: PER_GEN_HIERARCHY_NODES PGHN

644: NVL(HLEI.LEI_INFORMATION8
645: ,C_DEF_ACTIV_4)
646: FROM
647: HR_LOCATION_EXTRA_INFO HLEI,
648: PER_GEN_HIERARCHY_NODES PGHN
649: WHERE HLEI.INFORMATION_TYPE = 'EEO-1 Specific Information'
650: AND HLEI.LEI_INFORMATION_CATEGORY = 'EEO-1 Specific Information'
651: AND HLEI.LOCATION_ID = PGHN.ENTITY_ID
652: AND PGHN.PARENT_HIERARCHY_NODE_ID = C_PARENT_NODE_ID

Line 818: PER_GEN_HIERARCHY_NODES PGN

814: */
815: AND EXISTS (
816: SELECT 1
817: FROM
818: PER_GEN_HIERARCHY_NODES PGN
819: WHERE PGN.HIERARCHY_VERSION_ID = P_HIERARCHY_VERSION_ID
820: AND ( PGN.HIERARCHY_NODE_ID = EST_NODE_ID
821: OR PGN.PARENT_HIERARCHY_NODE_ID = EST_NODE_ID )
822: AND PGN.NODE_TYPE in ( 'EST' , 'LOC' )

Line 831: PER_GEN_HIERARCHY_NODES PGN

827: SELECT
828: DISTINCT
829: PGN.ENTITY_ID
830: FROM
831: PER_GEN_HIERARCHY_NODES PGN
832: WHERE ( PGN.HIERARCHY_NODE_ID = EST_NODE_ID
833: OR PGN.PARENT_HIERARCHY_NODE_ID = EST_NODE_ID )
834: AND PGN.HIERARCHY_VERSION_ID = P_HIERARCHY_VERSION_ID
835: AND PGN.NODE_TYPE in ( 'EST' , 'LOC' ) )

Line 878: PER_GEN_HIERARCHY_NODES PGN

874: SELECT
875: DISTINCT
876: PGN.ENTITY_ID
877: FROM
878: PER_GEN_HIERARCHY_NODES PGN
879: WHERE PGN.HIERARCHY_VERSION_ID = P_HIERARCHY_VERSION_ID
880: AND ( PGN.HIERARCHY_NODE_ID = EST_NODE_ID
881: OR PGN.PARENT_HIERARCHY_NODE_ID = EST_NODE_ID )
882: AND PGN.NODE_TYPE in ( 'EST' , 'LOC' ) );

Line 1004: PER_GEN_HIERARCHY_NODES

1000: */
1001: AND EXISTS (
1002: SELECT 1
1003: FROM
1004: PER_GEN_HIERARCHY_NODES
1005: WHERE HIERARCHY_VERSION_ID = P_HIERARCHY_VERSION_ID
1006: AND ASS.LOCATION_ID = ENTITY_ID)
1007: /* Replaced in clause with exists clause - bug#11736960
1008: AND ASS.LOCATION_ID in (

Line 1013: PER_GEN_HIERARCHY_NODES

1009: SELECT
1010: DISTINCT
1011: ENTITY_ID
1012: FROM
1013: PER_GEN_HIERARCHY_NODES
1014: WHERE HIERARCHY_VERSION_ID = P_HIERARCHY_VERSION_ID )
1015: */
1016: -- Added for bug#11736960
1017: AND EXISTS (SELECT 'X'

Line 1074: PER_GEN_HIERARCHY_NODES PGN,

1070: ELOC.LOCATION_ID,
1071: ELOC.LOCATION_CODE
1072: INTO L_LOCATION_ID,L_LOCATION_CODE
1073: FROM
1074: PER_GEN_HIERARCHY_NODES PGN,
1075: HR_LOCATIONS_ALL ELOC
1076: WHERE ( HIERARCHY_NODE_ID = EST_NODE_ID
1077: OR PARENT_HIERARCHY_NODE_ID = EST_NODE_ID )
1078: AND HIERARCHY_VERSION_ID = P_HIERARCHY_VERSION_ID

Line 1323: PER_GEN_HIERARCHY_NODES PGN

1319: AND HL.LOCATION_ID = ASS.LOCATION_ID
1320: AND EXISTS (
1321: SELECT 1
1322: FROM
1323: PER_GEN_HIERARCHY_NODES PGN
1324: WHERE PGN.HIERARCHY_VERSION_ID = P_HIERARCHY_VERSION_ID
1325: AND ( PGN.HIERARCHY_NODE_ID = EST_NODE_ID
1326: OR PGN.PARENT_HIERARCHY_NODE_ID = EST_NODE_ID )
1327: AND PGN.NODE_TYPE in ( 'EST' , 'LOC' )

Line 1336: PER_GEN_HIERARCHY_NODES PGN

1332: SELECT
1333: DISTINCT
1334: PGN.ENTITY_ID
1335: FROM
1336: PER_GEN_HIERARCHY_NODES PGN
1337: WHERE PGN.HIERARCHY_VERSION_ID = P_HIERARCHY_VERSION_ID
1338: AND ( PGN.HIERARCHY_NODE_ID = EST_NODE_ID
1339: OR PGN.PARENT_HIERARCHY_NODE_ID = EST_NODE_ID )
1340: AND PGN.NODE_TYPE in ( 'EST' , 'LOC' ) )