APPS.BSC_UPDATE_COLOR dependencies on BSC_KPI_ANALYSIS_MEASURES_B

Line 84: bsc_kpi_analysis_measures_b kpi_meas,

80: SELECT kpi_props.kpi_measure_id,
81: kpi_props.disable_color,
82: sys_dset.source
83: FROM bsc_kpi_measure_props kpi_props,
84: bsc_kpi_analysis_measures_b kpi_meas,
85: bsc_sys_datasets_b sys_dset
86: WHERE kpi_props.indicator = p_indicator
87: AND kpi_props.kpi_measure_id = kpi_meas.kpi_measure_id
88: AND kpi_meas.dataset_id = sys_dset.dataset_id;

Line 310: ,bsc_kpi_analysis_measures_b am

306: ELSE
307: SELECT color_method
308: INTO l_color_method
309: FROM bsc_sys_datasets_b ds
310: ,bsc_kpi_analysis_measures_b am
311: WHERE ds.dataset_id = am.dataset_id
312: AND am.indicator = p_objective_id
313: AND am.kpi_measure_id = p_kpi_measure_id;
314: END IF;