DBA Data[Home] [Help]

APPS.BSC_DESIGNER_PVT dependencies on BSC_SYS_DATASETS_B

Line 1158: FROM BSC_KPI_ANALYSIS_MEASURES_B B,BSC_SYS_FORMATS F,BSC_SYS_DATASETS_B DS

1154: WHERE INDICATOR = l_indicator;
1155:
1156: CURSOR c_analisys_measure IS
1157: SELECT B.SERIES_ID,F.FORMAT,DS.COLOR_METHOD
1158: FROM BSC_KPI_ANALYSIS_MEASURES_B B,BSC_SYS_FORMATS F,BSC_SYS_DATASETS_B DS
1159: WHERE INDICATOR = l_indicator
1160: AND B.ANALYSIS_OPTION0= h_a0
1161: AND B.ANALYSIS_OPTION1= h_a1
1162: AND B.ANALYSIS_OPTION2= h_a2

Line 1279: FROM BSC_SYS_DATASETS_B A,

1275: -- Changed for Bug#3753735
1276: h_kpi_measure_source :='BSC';
1277: SELECT NVL(SOURCE,'BSC')
1278: INTO h_Kpi_Measure_Source
1279: FROM BSC_SYS_DATASETS_B A,
1280: (SELECT DATASET_ID
1281: FROM BSC_KPI_ANALYSIS_MEASURES_B MS,
1282: BSC_DB_COLOR_AO_DEFAULTS_V DF
1283: WHERE ANALYSIS_OPTION0 = DF.A0_DEFAULT