APPS.MSD_VALIDATE_DEMAND_PLAN dependencies on MSD_CS_DEFN_COLUMN_DTLS_V

Line 650: FROM msd_cs_defn_column_dtls_v

646: --
647: CURSOR get_lvl_column_name(p_dim_code Varchar2,p_cs_id NUMBER) IS
648: SELECT decode(planning_view_column_name,'TIM_LEVEL_ID','TIME_LEVEL_ID',
649: planning_view_column_name)
650: FROM msd_cs_defn_column_dtls_v
651: WHERE column_identifier = upper(p_dim_code)||'_LEVEL_ID'
652: AND identifier_type = 'DIMENSION_ID'
653: AND cs_definition_id = p_cs_id;
654:

Line 3055: FROM msd_cs_defn_column_dtls_v

3051: function get_desig_clmn_name (p_cs_id in number) return VARCHAR2 IS
3052:
3053: CURSOR get_str_name (p_id NUMBER) IS
3054: SELECT planning_view_column_name
3055: FROM msd_cs_defn_column_dtls_v
3056: WHERE cs_definition_id = p_id
3057: AND identifier_type = 'CSIDEN';
3058:
3059: x_str_name varchar2(30);