DBA Data[Home] [Help]

APPS.PER_PERUSEO1_XMLP_PKG dependencies on PER_GEN_HIERARCHY_VERSIONS

Line 42: PER_GEN_HIERARCHY_VERSIONS PGV,

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