APPS.FII_UDD1_MAINTAIN_PKG dependencies on FII_DIM_NORM_HIERARCHY

Line 336: from FII_DIM_NORM_HIERARCHY

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

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

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

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

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

Line 394: From FII_DIM_NORM_HIERARCHY

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