[Home] [Help]
252: OR (h_kpi_type = 1 AND h_kpi_config = 7) THEN
253: BEGIN
254: SELECT COUNT(*) VAL
255: INTO h_series_count
256: FROM BSC_KPI_ANALYSIS_MEASURES_VL
257: WHERE ANALYSIS_OPTION0 =X_A0 AND
258: ANALYSIS_OPTION1 =X_A1 AND
259: ANALYSIS_OPTION2 =X_A2 AND
260: INDICATOR=X_INDICATOR;
260: INDICATOR=X_INDICATOR;
261: IF h_series_count >1 THEN
262: SELECT NAME
263: INTO h_series_name
264: FROM BSC_KPI_ANALYSIS_MEASURES_VL
265: WHERE ANALYSIS_OPTION0 =X_A0 AND
266: ANALYSIS_OPTION1 =X_A1 AND
267: ANALYSIS_OPTION2 =X_A2 AND
268: SERIES_ID = X_SERIES_ID AND