DBA Data[Home] [Help]

APPS.MSD_COLLECT_LEVEL_VALUES dependencies on MSD_DP_HIERARCHIES_V

Line 673: from msd_dp_hierarchies_v

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';

Line 713: from msd_dp_hierarchies_v

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: