APPS.HR_CAL_EVENT_MAPPING_PKG dependencies on PER_GEN_HIERARCHY_VERSIONS

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 616: l_ghv_ver_id per_gen_hierarchy_versions.hierarchy_version_id%TYPE;

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: --
620: -------------------------------------------------------------------------

Line 1089: per_gen_hierarchy_versions GHV,

1085: -- Cursor to fetch GEO Node Id
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