APPS.BSC_BIS_KPI_MEAS_PUB dependencies on BSC_DB_COLOR_AO_DEFAULTS_V

Line 5931: FROM bsc_db_color_ao_defaults_v dd, bsc_kpi_analysis_measures_vl km, bsc_kpis_b bk

5927: AND indicator = p_kpi_id;
5928:
5929: SELECT bk.color_rollup_type, km.kpi_measure_id, bk.prototype_flag
5930: INTO l_color_rollup_type, l_def_kpi_measure_id, l_obj_prototype_flag
5931: FROM bsc_db_color_ao_defaults_v dd, bsc_kpi_analysis_measures_vl km, bsc_kpis_b bk
5932: WHERE km.indicator = l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id AND
5933: bk.indicator = km.indicator AND
5934: km.indicator = dd.indicator AND
5935: dd.a0_default = km.analysis_option0 AND