APPS.MSD_LIABILITY dependencies on MSD_HIERARCHY_LEVELS_LB_V

Line 711: msd_hierarchy_levels_lb_v hl

707: hl.hierarchy_name,
708: hl.level_name,
709: hl.relationship_view
710: FROM msd_dp_hierarchies dh,
711: msd_hierarchy_levels_lb_v hl
712: WHERE demand_plan_id = p_demand_plan_id
713: AND dp_dimension_code <> 'TIM'
714: AND dh.hierarchy_id = hl.hierarchy_id
715: AND level_id NOT IN

Line 1112: from msd_hierarchy_levels_lb_v

1108: in a dimension
1109: ******************************************************/
1110: Cursor Dim_Level_Parent(p_dimension_code IN VARCHAR2) is
1111: select distinct level_id, parent_level_id, level_type_code
1112: from msd_hierarchy_levels_lb_v
1113: where owning_dimension_code = p_dimension_code
1114: order by level_type_code, level_id;
1115:
1116: /* Cursor to get levels alone */

Line 1119: from msd_hierarchy_levels_lb_v

1115:
1116: /* Cursor to get levels alone */
1117: Cursor Level_Cursor(p_dimension_code IN VARCHAR2) is
1118: select distinct level_id, level_type_code
1119: from msd_hierarchy_levels_lb_v
1120: where owning_dimension_code = p_dimension_code
1121: order by level_type_code, level_id;
1122:
1123: g_retcode varchar2(5) := '0';