APPS.HR_CAL_ENTRY_VALUE_API dependencies on PER_GEN_HIERARCHY_NODES

Line 608: select PARENT_HIERARCHY_NODE_ID from per_gen_hierarchy_nodes

604: --
605: -- also returns . delimited list of the node's parent ids
606: --
607: CURSOR csr_get_level IS
608: select PARENT_HIERARCHY_NODE_ID from per_gen_hierarchy_nodes
609: where HIERARCHY_VERSION_ID = P_HIERARCHY_VERSION_ID
610: connect by HIERARCHY_NODE_ID = prior PARENT_HIERARCHY_NODE_ID
611: AND HIERARCHY_VERSION_ID = P_HIERARCHY_VERSION_ID
612: start with HIERARCHY_NODE_ID = P_HIERARCHY_NODE_ID;