APPS.BSC_DATASETS_PVT dependencies on BSC_KPI_ANALYSIS_MEASURES_B

Line 466: FROM bsc_kpi_analysis_measures_b am,

462: l_prototype_flag BSC_NUM_LIST;
463:
464: CURSOR indicators_cursor is
465: SELECT am.indicator, kpi.prototype_flag
466: FROM bsc_kpi_analysis_measures_b am,
467: bsc_kpis_b kpi
468: WHERE kpi.indicator = am.indicator
469: AND dataset_id = p_Dataset_Rec.Bsc_Dataset_Id;
470:

Line 1202: FROM BSC_KPI_ANALYSIS_MEASURES_b

1198: l_indicator_table BSC_NUM_LIST;
1199:
1200: CURSOR c_Default_Measure_In_Indicator IS
1201: SELECT DISTINCT INDICATOR
1202: FROM BSC_KPI_ANALYSIS_MEASURES_b
1203: WHERE DATASET_ID =p_Dataset_Rec.Bsc_Dataset_Id;
1204:
1205:
1206:

Line 1209: FROM bsc_kpi_analysis_measures_b b,

1205:
1206:
1207: CURSOR indicators_cursor IS
1208: SELECT b.indicator
1209: FROM bsc_kpi_analysis_measures_b b,
1210: bsc_kpis_b a
1211: WHERE a.indicator =b.indicator
1212: AND a.config_type <>3
1213: AND b.dataset_id = p_Dataset_Rec.Bsc_Dataset_Id;

Line 1217: l_kpi_measure_id BSC_KPI_ANALYSIS_MEASURES_B.KPI_MEASURE_ID%TYPE;

1213: AND b.dataset_id = p_Dataset_Rec.Bsc_Dataset_Id;
1214:
1215: l_kpi_flag number;
1216: l_color_Method_flag boolean;
1217: l_kpi_measure_id BSC_KPI_ANALYSIS_MEASURES_B.KPI_MEASURE_ID%TYPE;
1218:
1219: begin
1220:
1221: l_color_Method_flag := false;

Line 1418: FROM bsc_kpi_analysis_measures_b

1414: END IF;
1415: IF (l_color_Method_flag) THEN
1416: SELECT kpi_measure_id
1417: INTO l_kpi_measure_id
1418: FROM bsc_kpi_analysis_measures_b
1419: WHERE indicator = l_indicator_table(i)
1420: AND dataset_id = p_Dataset_Rec.Bsc_Dataset_Id;
1421:
1422: BSC_COLOR_RANGES_PUB.Delete_Color_Prop_Ranges (p_objective_id => l_indicator_table(i)