DBA Data[Home] [Help]

APPS.BSC_BIS_MEASURE_PUB dependencies on BSC_KPI_ANALYSIS_MEASURES_VL

Line 2828: FROM BSC_KPI_ANALYSIS_MEASURES_VL

2824: l_count NUMBER := 0;
2825:
2826: CURSOR c_SeriesCount IS
2827: SELECT COUNT(SERIES_ID)
2828: FROM BSC_KPI_ANALYSIS_MEASURES_VL
2829: WHERE INDICATOR = p_indicator
2830: AND ANALYSIS_OPTION0 = p_a0
2831: AND ANALYSIS_OPTION1 = p_a1
2832: AND ANALYSIS_OPTION2 = p_a2;

Line 4006: BSC_KPI_ANALYSIS_MEASURES_VL B,

4002:
4003: cursor c_Dataset_Color is
4004: select B.DATASET_ID DATASET_ID, C.COLOR_METHOD COLOR_METHOD
4005: from BSC_OAF_ANALYSYS_OPT_COMB_V A,
4006: BSC_KPI_ANALYSIS_MEASURES_VL B,
4007: BSC_SYS_DATASETS_VL C
4008: where A.INDICATOR = B.INDICATOR
4009: and A.SERIES_ID = B.SERIES_ID
4010: and A.ANALYSIS_OPTION0 = B.ANALYSIS_OPTION0