DBA Data[Home] [Help]

APPS.PER_PERUSEOC_XMLP_PKG dependencies on PER_GEN_HIERARCHY_VERSIONS

Line 35: PER_GEN_HIERARCHY_VERSIONS PGV,

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