APPS.FII_COM_MAINTAIN_PKG dependencies on FII_DIM_NORM_HIERARCHY

Line 338: from FII_DIM_NORM_HIERARCHY

334: PROCEDURE Get_NORM_HIERARCHY_TMP IS
335:
336: Cursor all_local_value_sets IS
337: select distinct child_flex_value_set_id
338: from FII_DIM_NORM_HIERARCHY
339: where parent_flex_value_set_id = G_MASTER_VALUE_SET_ID
340: and parent_flex_value_set_id <> child_flex_value_set_id
341: and child_flex_value_set_id IN
342: (select map.flex_value_set_id1

Line 380: --Copy table FII_DIM_NORM_HIERARCHY for parent-child valuesets relation

376: From FND_FLEX_VALUE_NORM_HIERARCHY
377: Where flex_value_set_id = G_MASTER_VALUE_SET_ID;
378:
379:
380: --Copy table FII_DIM_NORM_HIERARCHY for parent-child valuesets relation
381: g_phase := 'Copy FII_DIM_NORM_HIERARCHY for parent-child valuesets relation';
382: Insert into FII_DIM_NORM_HIER_GT (
383: PARENT_FLEX_VALUE_SET_ID,
384: PARENT_FLEX_VALUE,

Line 381: g_phase := 'Copy FII_DIM_NORM_HIERARCHY for parent-child valuesets relation';

377: Where flex_value_set_id = G_MASTER_VALUE_SET_ID;
378:
379:
380: --Copy table FII_DIM_NORM_HIERARCHY for parent-child valuesets relation
381: g_phase := 'Copy FII_DIM_NORM_HIERARCHY for parent-child valuesets relation';
382: Insert into FII_DIM_NORM_HIER_GT (
383: PARENT_FLEX_VALUE_SET_ID,
384: PARENT_FLEX_VALUE,
385: RANGE_ATTRIBUTE,

Line 396: From FII_DIM_NORM_HIERARCHY

392: RANGE_ATTRIBUTE,
393: CHILD_FLEX_VALUE_SET_ID,
394: CHILD_FLEX_VALUE_LOW,
395: CHILD_FLEX_VALUE_HIGH
396: From FII_DIM_NORM_HIERARCHY
397: Where PARENT_FLEX_VALUE_SET_ID <> CHILD_FLEX_VALUE_SET_ID
398: AND PARENT_FLEX_VALUE_SET_ID = G_MASTER_VALUE_SET_ID
399: And CHILD_FLEX_VALUE_SET_ID IN
400: (select map.flex_value_set_id1