APPS.PER_PERUSEOC_XMLP_PKG dependencies on PER_GEN_HIERARCHY_NODES

Line 36: PER_GEN_HIERARCHY_NODES PGN

32: INTO C_HIERARCHY_NAME,C_HIERARCHY_VERSION_NUM,C_PARENT_ORG_ID,C_PARENT_NODE_ID
33: FROM
34: PER_GEN_HIERARCHY PGH,
35: PER_GEN_HIERARCHY_VERSIONS PGV,
36: PER_GEN_HIERARCHY_NODES PGN
37: WHERE PGH.HIERARCHY_ID = P_HIERARCHY_ID
38: AND PGH.HIERARCHY_ID = PGV.HIERARCHY_ID
39: AND PGV.HIERARCHY_VERSION_ID = P_HIERARCHY_VERSION_ID
40: 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: /*SRW.MESSAGE('40'
58: ,'p_audit_report : ' || P_AUDIT_REPORT)*/NULL;

Line 397: PER_GEN_HIERARCHY_NODES PGHN,

393: AND ASS.LOCATION_ID in (
394: SELECT
395: ENTITY_ID
396: FROM
397: PER_GEN_HIERARCHY_NODES PGHN,
398: HR_LOCATION_EXTRA_INFO HLEI1,
399: HR_LOCATION_EXTRA_INFO HLEI2
400: WHERE PGHN.NODE_TYPE <> 'PAR'
401: AND HIERARCHY_VERSION_ID = P_HIERARCHY_VERSION_ID