APPS.MSD_COMPOSITE_GROUPING dependencies on MSD_CS_DEFN_DIM_DTLS

Line 275: FROM msd_cs_defn_dim_dtls a, msd_cs_definitions b

271: COLLECT_LEVEL_ID )
272: SELECT a.cs_definition_id,
273: a.dimension_code,
274: a.collect_level_id
275: FROM msd_cs_defn_dim_dtls a, msd_cs_definitions b
276: WHERE a.cs_definition_id = b.cs_definition_id
277: AND b.cs_definition_id = lv_stream_id
278: AND a.dimension_code <> 'TIM'
279: AND a.collect_flag='Y'

Line 366: FROM msd_cs_defn_dim_dtls a, msd_cs_definitions b

362: COLLECT_LEVEL_ID )
363: SELECT a.cs_definition_id,
364: a.dimension_code,
365: a.collect_level_id
366: FROM msd_cs_defn_dim_dtls a, msd_cs_definitions b
367: WHERE a.cs_definition_id = b.cs_definition_id
368: AND b.cs_definition_id = lv_stream_id
369: AND a.dimension_code <> 'TIM'
370: AND a.collect_flag='Y'

Line 471: FROM msd_cs_defn_dim_dtls a, msd_cs_definitions b

467: COLLECT_LEVEL_ID )
468: SELECT a.cs_definition_id,
469: a.dimension_code,
470: a.collect_level_id
471: FROM msd_cs_defn_dim_dtls a, msd_cs_definitions b
472: WHERE a.cs_definition_id = b.cs_definition_id
473: AND b.cs_definition_id = lv_stream_id
474: AND a.dimension_code <> 'TIM'
475: AND a.collect_flag='Y'

Line 811: FROM msd_cs_defn_dim_dtls a, msd_cs_definitions b

807: FROM msd_cs_data x;
808:
809: CURSOR c1 IS
810: SELECT a.cs_definition_id,a.dimension_code,a.collect_level_id
811: FROM msd_cs_defn_dim_dtls a, msd_cs_definitions b
812: WHERE a.cs_definition_id = b.cs_definition_id
813: AND a.dimension_code <> 'TIM'
814: AND a.collect_flag='Y'
815: AND b.strict_flag='Y'