APPS.MSD_VALIDATE_DEMAND_PLAN dependencies on MSD_CS_DEFN_COLUMN_DTLS_V

Line 655: FROM msd_cs_defn_column_dtls_v

651: --
652: CURSOR get_lvl_column_name(p_dim_code Varchar2,p_cs_id NUMBER) IS
653: SELECT decode(planning_view_column_name,'TIM_LEVEL_ID','TIME_LEVEL_ID',
654: planning_view_column_name)
655: FROM msd_cs_defn_column_dtls_v
656: WHERE column_identifier = upper(p_dim_code)||'_LEVEL_ID'
657: AND identifier_type = 'DIMENSION_ID'
658: AND cs_definition_id = p_cs_id;
659:

Line 3188: FROM msd_cs_defn_column_dtls_v

3184: function get_desig_clmn_name (p_cs_id in number) return VARCHAR2 IS
3185:
3186: CURSOR get_str_name (p_id NUMBER) IS
3187: SELECT planning_view_column_name
3188: FROM msd_cs_defn_column_dtls_v
3189: WHERE cs_definition_id = p_id
3190: AND identifier_type = 'CSIDEN';
3191:
3192: x_str_name varchar2(30);