APPS.MSD_COLLECT_LEVEL_VALUES dependencies on MSD_HIERARCHY_LEVELS_V

Line 414: from msd_hierarchy_levels_v

410: Cursor to get distinct Level, Parent Combinations
411: ******************************************************/
412: Cursor Level_Parent(p_level_id IN NUMBER) is
413: select distinct level_id, parent_level_id, level_type_code
414: from msd_hierarchy_levels_v
415: where level_id = p_level_id
416: order by level_type_code, level_id;
417: Begin
418:

Line 483: from msd_hierarchy_levels_v

479: a hierarchy
480: ******************************************************/
481: Cursor Hierarchy_Levels(p_hierarchy_id IN NUMBER) is
482: select level_id, parent_level_id, level_type_code
483: from msd_hierarchy_levels_v
484: where hierarchy_id = p_hierarchy_id
485: order by level_type_code, level_id;
486:
487: /* Cursor to get distinct levels in the hierarchy */

Line 490: from msd_hierarchy_levels_v

486:
487: /* Cursor to get distinct levels in the hierarchy */
488: Cursor Level_Cursor(p_hierarchy_id IN NUMBER) is
489: select distinct level_id, level_type_code
490: from msd_hierarchy_levels_v
491: where hierarchy_id = p_hierarchy_id
492: order by level_type_code, level_id;
493:
494: Cursor hierarcy_dimension(p_hierarchy_id IN NUMBER) is

Line 496: from msd_hierarchy_levels_v

492: order by level_type_code, level_id;
493:
494: Cursor hierarcy_dimension(p_hierarchy_id IN NUMBER) is
495: select distinct OWNING_DIMENSION_CODE
496: from msd_hierarchy_levels_v
497: where hierarchy_id = p_hierarchy_id;
498:
499: l_dim_code varchar(5) := null;
500: g_retcode varchar2(5) := '0';

Line 584: from msd_hierarchy_levels_v

580: in a dimension
581: ******************************************************/
582: Cursor Dim_Level_Parent(p_dimension_code IN VARCHAR2) is
583: select distinct level_id, parent_level_id, level_type_code
584: from msd_hierarchy_levels_v
585: where owning_dimension_code = p_dimension_code
586: order by level_type_code, level_id;
587:
588: /* Cursor to get levels alone */

Line 591: from msd_hierarchy_levels_v

587:
588: /* Cursor to get levels alone */
589: Cursor Level_Cursor(p_dimension_code IN VARCHAR2) is
590: select distinct level_id, level_type_code
591: from msd_hierarchy_levels_v
592: where owning_dimension_code = p_dimension_code
593: order by level_type_code, level_id;
594:
595: g_retcode varchar2(5) := '0';