DBA Data[Home] [Help]

APPS.PER_PERUSEOC_XMLP_PKG dependencies on PER_GEN_HIERARCHY_VERSIONS

Line 39: PER_GEN_HIERARCHY_VERSIONS PGV,

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