APPS.BSC_COLOR_RANGES_PUB dependencies on BSC_KPI_ANALYSIS_MEASURES_B

Line 246: FROM bsc_kpi_analysis_measures_b am

242: IF (p_kpi_measure_id IS NOT NULL) THEN
243: SELECT am.analysis_option0,
244: am.analysis_option1, am.analysis_option2, am.series_id
245: INTO l_an_opt0, l_an_opt1, l_an_opt2, l_series_id
246: FROM bsc_kpi_analysis_measures_b am
247: WHERE am.indicator = p_objective_id
248: AND am.kpi_measure_id = p_kpi_measure_id;
249: END IF;
250:

Line 261: FROM bsc_kpi_analysis_measures_b

257:
258: IF (p_kpi_measure_id IS NOT NULL) THEN
259: SELECT kpi_measure_id
260: INTO l_kpi_measure_id
261: FROM bsc_kpi_analysis_measures_b
262: WHERE indicator= c_shared.indicator
263: AND analysis_option0 = l_an_opt0
264: AND analysis_option1 = l_an_opt1
265: AND analysis_option2 = l_an_opt2

Line 405: ,bsc_kpi_analysis_measures_b am

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;
409: END IF;

Line 923: FROM bsc_color_type_props cprop, bsc_kpi_analysis_measures_b am

919: IF (p_kpi_measure_id IS NOT NULL) THEN
920: SELECT am.analysis_option0, am.analysis_option1,
921: am.analysis_option2, am.series_id
922: INTO l_an_opt0, l_an_opt1, l_an_opt2, l_series_id
923: FROM bsc_color_type_props cprop, bsc_kpi_analysis_measures_b am
924: WHERE cprop.kpi_measure_id = am.kpi_measure_id
925: AND cprop.indicator = am.indicator
926: AND color_range_id = l_color_range_ids_rec.color_range_id;
927: END IF;

Line 945: FROM bsc_kpi_analysis_measures_b

941: AND kpi_measure_id IS NULL;
942: ELSE
943: SELECT kpi_measure_id
944: INTO l_kpi_measure_id
945: FROM bsc_kpi_analysis_measures_b
946: WHERE indicator= c_shared.indicator
947: AND analysis_option0 = l_an_opt0
948: AND analysis_option1 = l_an_opt1
949: AND analysis_option2 = l_an_opt2

Line 1306: FROM bsc_kpi_analysis_measures_b am

1302: IF (l_kpi_measure_id IS NOT NULL) THEN
1303: SELECT am.analysis_option0,
1304: am.analysis_option1, am.analysis_option2, am.series_id
1305: INTO l_an_opt0, l_an_opt1, l_an_opt2, l_series_id
1306: FROM bsc_kpi_analysis_measures_b am
1307: WHERE am.indicator = p_objective_id
1308: AND am.kpi_measure_id = l_kpi_measure_id;
1309: END IF;
1310:

Line 1327: FROM bsc_kpi_analysis_measures_b

1323: END LOOP;
1324: ELSE
1325: SELECT kpi_measure_id
1326: INTO l_kpi_measure_id
1327: FROM bsc_kpi_analysis_measures_b
1328: WHERE indicator= c_shared.indicator
1329: AND analysis_option0 = l_an_opt0
1330: AND analysis_option1 = l_an_opt1
1331: AND analysis_option2 = l_an_opt2

Line 1421: FROM bsc_color_type_props cprop, bsc_kpi_analysis_measures_b am

1417: SELECT cprop.indicator, am.analysis_option0,
1418: am.analysis_option1, am.analysis_option2, am.series_id,
1419: cprop.property_value
1420: INTO l_objective_id, l_an_opt0, l_an_opt1, l_an_opt2, l_series_id, l_property_value
1421: FROM bsc_color_type_props cprop, bsc_kpi_analysis_measures_b am
1422: WHERE cprop.kpi_measure_id = am.kpi_measure_id
1423: AND color_range_id = p_color_range_id;
1424:
1425: FOR c_shared IN c_shared_obj LOOP

Line 1428: FROM bsc_kpi_analysis_measures_b

1424:
1425: FOR c_shared IN c_shared_obj LOOP
1426: SELECT kpi_measure_id
1427: INTO l_kpi_measure_id
1428: FROM bsc_kpi_analysis_measures_b
1429: WHERE indicator= c_shared.indicator
1430: AND analysis_option0 = l_an_opt0
1431: AND analysis_option1 = l_an_opt1
1432: AND analysis_option2 = l_an_opt2

Line 1499: FROM bsc_kpi_analysis_measures_b am

1495: WHERE indicator = p_objective_id;
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;