APPS.HR_CAL_EVENT_MAPPING_PKG dependencies on PER_GEN_HIERARCHY_NODES

Line 566: FROM per_gen_hierarchy_nodes

562: -- Cursor to fetch the top of the hierarchy
563: CURSOR c_geo_hier_top (cp_ghv_id NUMBER
564: ) IS
565: SELECT hierarchy_node_id
566: FROM per_gen_hierarchy_nodes
567: WHERE hierarchy_version_id = cp_ghv_id
568: AND parent_hierarchy_node_id IS NULL;
569:
570: -- Cursor to walk the GEO hierarchy and return all nodes and levels

Line 578: FROM per_gen_hierarchy_nodes

574: SELECT LEVEL
575: ,hierarchy_version_id
576: ,hierarchy_node_id
577: ,entity_id
578: FROM per_gen_hierarchy_nodes
579: WHERE hierarchy_version_id = cp_ghv_id
580: START WITH hierarchy_node_id = cp_top_node_id
581: CONNECT BY PRIOR hierarchy_node_id = parent_hierarchy_node_id;
582:

Line 615: l_top_node_id per_gen_hierarchy_nodes.hierarchy_node_id%TYPE;

611:
612: -- Local variables for process_geo_list
613: l_geo_hier_table t_geo_hier_table;
614: l_cal_event_table t_cal_event_table;
615: l_top_node_id per_gen_hierarchy_nodes.hierarchy_node_id%TYPE;
616: l_ghv_ver_id per_gen_hierarchy_versions.hierarchy_version_id%TYPE;
617: l_proc VARCHAR2(100);
618:
619: --

Line 1090: per_gen_hierarchy_nodes GHN

1086: CURSOR c_geo_node_id (cp_geo_node VARCHAR2) IS
1087: SELECT GHN.hierarchy_node_id
1088: FROM per_gen_hierarchy GH,
1089: per_gen_hierarchy_versions GHV,
1090: per_gen_hierarchy_nodes GHN
1091: WHERE GH.type = 'PER_CAL_GEO'
1092: AND GH.hierarchy_id = GHV.hierarchy_id
1093: AND GHV.version_number = 1
1094: AND GHV.hierarchy_version_id = GHN.hierarchy_version_id