DBA Data[Home] [Help]

APPS.PER_PERUSE1L_XMLP_PKG dependencies on PER_GEN_HIERARCHY_VERSIONS

Line 43: PER_GEN_HIERARCHY_VERSIONS PGV,

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