APPS.PER_PERUSEOC_XMLP_PKG dependencies on PER_GEN_HIERARCHY_NODES

Line 40: PER_GEN_HIERARCHY_NODES PGN

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

Line 58: PER_GEN_HIERARCHY_NODES PGHN

54: SELECT
55: COUNT(PGHN.HIERARCHY_NODE_ID)
56: INTO C_NO_OF_ESTABLISHMENTS
57: FROM
58: PER_GEN_HIERARCHY_NODES PGHN
59: WHERE PGHN.HIERARCHY_VERSION_ID = P_HIERARCHY_VERSION_ID
60: AND PGHN.NODE_TYPE = 'EST';
61: /*SRW.MESSAGE('40'
62: ,'p_audit_report : ' || P_AUDIT_REPORT)*/NULL;

Line 431: PER_GEN_HIERARCHY_NODES PGHN,

427: AND ASS.LOCATION_ID in (
428: SELECT
429: ENTITY_ID
430: FROM
431: PER_GEN_HIERARCHY_NODES PGHN,
432: HR_LOCATION_EXTRA_INFO HLEI1,
433: HR_LOCATION_EXTRA_INFO HLEI2
434: WHERE PGHN.NODE_TYPE <> 'PAR'
435: AND HIERARCHY_VERSION_ID = P_HIERARCHY_VERSION_ID