1936: --
1937: -- A record is created only if there is no existing relationship for a
1938: -- given child.
1939: --
1940: MERGE INTO FEM_CAL_PERIODS_HIER H
1941: USING (
1942: SELECT -- Termination points (Year)
1943: pv_cal_per_hier_obj_def_id HIERARCHY_OBJ_DEF_ID,
1944: 1 PARENT_DEPTH_NUM,
2029: --
2030: -- A record is created only if there is no existing relationship for a
2031: -- given child.
2032: --
2033: MERGE INTO FEM_CAL_PERIODS_HIER H
2034: USING (
2035: SELECT
2036: pv_cal_per_hier_obj_def_id HIERARCHY_OBJ_DEF_ID,
2037: 2 PARENT_DEPTH_NUM,