669: Cursor to get distinct owning dimensions in a dp dimension
670: ******************************************************/
671: Cursor Dp_Dim_Dimensions(p_dimension_code IN VARCHAR2) is
672: select distinct owning_dimension_code
673: from msd_dp_hierarchies_v
674: where demand_plan_id = p_demand_plan_id
675: and dp_dimension_code = p_dimension_code ;
676:
677: g_retcode varchar2(5) := '0';
709: Cursor to get DP_Dimensions in a demand plan
710: ******************************************************/
711: Cursor Dp_Dimensions(p_demand_plan_id IN NUMBER) is
712: select distinct dp_dimension_code
713: from msd_dp_hierarchies_v
714: where demand_plan_id = p_demand_plan_id ;
715:
716: g_retcode varchar2(5) := '0';
717: