APPS.HR_CAL_EVENT_MAPPING_PKG dependencies on PER_GEN_HIERARCHY

Line 556: FROM per_gen_hierarchy_versions

552: -- Cursor to fetch the version id of GHV
553: CURSOR c_ghv_ver_id (cp_ghv_id NUMBER
554: ) IS
555: SELECT hierarchy_version_id
556: FROM per_gen_hierarchy_versions
557: WHERE hierarchy_id = cp_ghv_id
558: AND version_number = (SELECT MAX(version_number)
559: FROM per_gen_hierarchy_versions
560: WHERE hierarchy_id = cp_ghv_id);

Line 559: FROM per_gen_hierarchy_versions

555: SELECT hierarchy_version_id
556: FROM per_gen_hierarchy_versions
557: WHERE hierarchy_id = cp_ghv_id
558: AND version_number = (SELECT MAX(version_number)
559: FROM per_gen_hierarchy_versions
560: WHERE hierarchy_id = cp_ghv_id);
561:
562: -- Cursor to fetch the top of the hierarchy
563: CURSOR c_geo_hier_top (cp_ghv_id NUMBER

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 616: l_top_node_id per_gen_hierarchy_nodes.hierarchy_node_id%TYPE;

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

Line 617: l_ghv_ver_id per_gen_hierarchy_versions.hierarchy_version_id%TYPE;

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

Line 1126: FROM per_gen_hierarchy GH,

1122:
1123: -- Cursor to fetch GEO Node Id
1124: CURSOR c_geo_node_id (cp_geo_node VARCHAR2) IS
1125: SELECT GHN.hierarchy_node_id
1126: FROM per_gen_hierarchy GH,
1127: per_gen_hierarchy_versions GHV,
1128: per_gen_hierarchy_nodes GHN
1129: WHERE GH.type = 'PER_CAL_GEO'
1130: AND GH.hierarchy_id = GHV.hierarchy_id

Line 1127: per_gen_hierarchy_versions GHV,

1123: -- Cursor to fetch GEO Node Id
1124: CURSOR c_geo_node_id (cp_geo_node VARCHAR2) IS
1125: SELECT GHN.hierarchy_node_id
1126: FROM per_gen_hierarchy GH,
1127: per_gen_hierarchy_versions GHV,
1128: per_gen_hierarchy_nodes GHN
1129: WHERE GH.type = 'PER_CAL_GEO'
1130: AND GH.hierarchy_id = GHV.hierarchy_id
1131: AND GHV.version_number = 1

Line 1128: per_gen_hierarchy_nodes GHN

1124: CURSOR c_geo_node_id (cp_geo_node VARCHAR2) IS
1125: SELECT GHN.hierarchy_node_id
1126: FROM per_gen_hierarchy GH,
1127: per_gen_hierarchy_versions GHV,
1128: per_gen_hierarchy_nodes GHN
1129: WHERE GH.type = 'PER_CAL_GEO'
1130: AND GH.hierarchy_id = GHV.hierarchy_id
1131: AND GHV.version_number = 1
1132: AND GHV.hierarchy_version_id = GHN.hierarchy_version_id