APPS.FII_LOB_MAINTAIN_PKG dependencies on FII_DIM_NORM_HIERARCHY

Line 360: from FII_DIM_NORM_HIERARCHY

356: PROCEDURE Get_NORM_HIERARCHY_TMP IS
357:
358: Cursor all_local_value_sets IS
359: select distinct child_flex_value_set_id
360: from FII_DIM_NORM_HIERARCHY
361: where parent_flex_value_set_id = G_MASTER_VALUE_SET_ID
362: and parent_flex_value_set_id <> child_flex_value_set_id
363: and child_flex_value_set_id IN
364: (select map.flex_value_set_id1

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

405: -- For DBI 5.0 customers, use the master value set only
406: -- For DBI 6.0, need to get all child value sets
407: IF G_LOB_DBI50_SETUP <> 'Y' THEN
408:
409: --Copy table FII_DIM_NORM_HIERARCHY for parent-child valuesets relation
410: g_phase := 'Copy FII_DIM_NORM_HIERARCHY for parent-child valuesets relation';
411:
412: Insert into FII_DIM_NORM_HIER_GT (
413: PARENT_FLEX_VALUE_SET_ID,

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

406: -- For DBI 6.0, need to get all child value sets
407: IF G_LOB_DBI50_SETUP <> 'Y' THEN
408:
409: --Copy table FII_DIM_NORM_HIERARCHY for parent-child valuesets relation
410: g_phase := 'Copy FII_DIM_NORM_HIERARCHY for parent-child valuesets relation';
411:
412: Insert into FII_DIM_NORM_HIER_GT (
413: PARENT_FLEX_VALUE_SET_ID,
414: PARENT_FLEX_VALUE,

Line 426: From FII_DIM_NORM_HIERARCHY

422: RANGE_ATTRIBUTE,
423: CHILD_FLEX_VALUE_SET_ID,
424: CHILD_FLEX_VALUE_LOW,
425: CHILD_FLEX_VALUE_HIGH
426: From FII_DIM_NORM_HIERARCHY
427: Where PARENT_FLEX_VALUE_SET_ID <> CHILD_FLEX_VALUE_SET_ID
428: AND PARENT_FLEX_VALUE_SET_ID = G_MASTER_VALUE_SET_ID -- Bug 4018002. Multiple dimensions may have same LVS.
429: And CHILD_FLEX_VALUE_SET_ID IN
430: (select map.flex_value_set_id1