1504: where name = p_cs_defn_name;
1505:
1506: cursor c2(p_cs_id in number) is
1507: select dimension_code
1508: from msd_cs_defn_dim_dtls
1509: where cs_definition_id = p_cs_id
1510: and collect_flag = C_YES_FLAG
1511: and dimension_code <> 'TIM';
1512:
2670: where name = p_name;
2671:
2672: cursor get_dim_col_id (p_cs_id in number) is
2673: SELECT collect_level_id
2674: FROM msd_cs_defn_dim_dtls
2675: where dimension_code = p_dim_code
2676: and collect_flag = 'Y'
2677: and cs_definition_id = p_cs_id;
2678:
2894: where name = p_name;
2895:
2896: cursor get_dim_col_id (p_cs_id in number) is
2897: SELECT collect_level_id
2898: FROM msd_cs_defn_dim_dtls
2899: where dimension_code = p_dim_code
2900: and collect_flag = 'Y'
2901: and cs_definition_id = p_cs_id;
2902: