330: PROCEDURE Get_NORM_HIERARCHY_TMP IS
331:
332: Cursor all_local_value_sets IS
333: select distinct child_flex_value_set_id
334: from FII_DIM_NORM_HIERARCHY
335: where parent_flex_value_set_id = G_MASTER_VALUE_SET_ID
336: and parent_flex_value_set_id <> child_flex_value_set_id
337: and child_flex_value_set_id IN
338: (select map.flex_value_set_id1
371: From FND_FLEX_VALUE_NORM_HIERARCHY
372: Where flex_value_set_id = G_MASTER_VALUE_SET_ID;
373:
374:
375: --Copy table FII_DIM_NORM_HIERARCHY for parent-child valuesets relation
376: g_phase := 'Copy FII_DIM_NORM_HIERARCHY for parent-child valuesets relation';
377: Insert into FII_DIM_NORM_HIER_GT (
378: PARENT_FLEX_VALUE_SET_ID,
379: PARENT_FLEX_VALUE,
372: Where flex_value_set_id = G_MASTER_VALUE_SET_ID;
373:
374:
375: --Copy table FII_DIM_NORM_HIERARCHY for parent-child valuesets relation
376: g_phase := 'Copy FII_DIM_NORM_HIERARCHY for parent-child valuesets relation';
377: Insert into FII_DIM_NORM_HIER_GT (
378: PARENT_FLEX_VALUE_SET_ID,
379: PARENT_FLEX_VALUE,
380: RANGE_ATTRIBUTE,
387: RANGE_ATTRIBUTE,
388: CHILD_FLEX_VALUE_SET_ID,
389: CHILD_FLEX_VALUE_LOW,
390: CHILD_FLEX_VALUE_HIGH
391: From FII_DIM_NORM_HIERARCHY
392: Where PARENT_FLEX_VALUE_SET_ID <> CHILD_FLEX_VALUE_SET_ID
393: AND PARENT_FLEX_VALUE_SET_ID = G_MASTER_VALUE_SET_ID
394: And CHILD_FLEX_VALUE_SET_ID IN
395: (select map.flex_value_set_id1