DBA Data[Home] [Help]

APPS.MSD_COLLECT_LEVEL_VALUES dependencies on MSD_DP_HIERARCHIES_V

Line 756: from msd_dp_hierarchies_v

752: Cursor to get distinct owning dimensions in a dp dimension
753: ******************************************************/
754: Cursor Dp_Dim_Dimensions(p_dimension_code IN VARCHAR2) is
755: select distinct owning_dimension_code
756: from msd_dp_hierarchies_v
757: where demand_plan_id = p_demand_plan_id
758: and dp_dimension_code = p_dimension_code ;
759:
760: g_retcode varchar2(5) := '0';

Line 796: from msd_dp_hierarchies_v

792: Cursor to get DP_Dimensions in a demand plan
793: ******************************************************/
794: Cursor Dp_Dimensions(p_demand_plan_id IN NUMBER) is
795: select distinct dp_dimension_code
796: from msd_dp_hierarchies_v
797: where demand_plan_id = p_demand_plan_id ;
798:
799: g_retcode varchar2(5) := '0';
800: