APPS.BSC_COLOR_RANGES_PUB dependencies on BSC_SYS_DATASETS_B

Line 404: FROM bsc_sys_datasets_b ds

400: l_color_method := p_property_value;
401: ELSE
402: SELECT ds.color_method
403: INTO l_color_method
404: FROM bsc_sys_datasets_b ds
405: ,bsc_kpi_analysis_measures_b am
406: WHERE ds.dataset_id = am.dataset_id
407: AND am.indicator = p_objective_id
408: AND am.kpi_measure_id = p_kpi_measure_id;

Line 1500: ,bsc_sys_datasets_b ds

1496: ELSE
1497: SELECT color_method
1498: INTO l_color_method
1499: FROM bsc_kpi_analysis_measures_b am
1500: ,bsc_sys_datasets_b ds
1501: WHERE am.dataset_id = ds.dataset_id
1502: AND kpi_measure_id = p_kpi_measure_id;
1503: END IF;
1504: RETURN l_color_method;