DBA Data[Home] [Help]

APPS.BSC_KPI_COLOR_PROPERTIES_PUB dependencies on BSC_DB_COLOR_AO_DEFAULTS_V

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

309: WHERE indicator = p_objective_id;*/
310:
311: SELECT bk.color_rollup_type, bk.prototype_flag
312: INTO l_color_rollup_type, l_obj_prototype_flag
313: FROM bsc_db_color_ao_defaults_v dd, bsc_kpi_analysis_measures_vl km, bsc_kpis_b bk
314: WHERE km.indicator = p_objective_id AND
315: bk.indicator = km.indicator AND
316: km.indicator = dd.indicator AND
317: dd.a0_default = km.analysis_option0 AND

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

579: WHERE indicator = p_objective_id;*/
580:
581: SELECT bk.color_rollup_type, km.kpi_measure_id, bk.prototype_flag
582: INTO l_color_rollup_type, l_def_kpi_measure_id, l_obj_prototype_flag
583: FROM bsc_db_color_ao_defaults_v dd, bsc_kpi_analysis_measures_vl km, bsc_kpis_b bk
584: WHERE km.indicator = p_objective_id AND
585: bk.indicator = km.indicator AND
586: km.indicator = dd.indicator AND
587: dd.a0_default = km.analysis_option0 AND