DBA Data[Home] [Help]

APPS.PER_PERUSEO1_XMLP_PKG dependencies on PER_GEN_HIERARCHY_VERSIONS

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