APPS.BSC_COLOR_UPGRADE dependencies on BSC_SYS_DATASETS_B

Line 171: FROM bsc_sys_datasets_b dts,

167: l_obj_sh_name BSC_KPIS_B.short_name%TYPE;
168:
169: CURSOR c_measure_source(pkpi_measure_id NUMBER) IS
170: SELECT source
171: FROM bsc_sys_datasets_b dts,
172: bsc_kpi_analysis_measures_b am
173: WHERE dts.dataset_id = am.dataset_id
174: AND am.kpi_measure_id = pkpi_measure_id;
175:

Line 1111: ,bsc_sys_datasets_b ds

1107: CURSOR c_anal_measures IS
1108: SELECT an.kpi_measure_id
1109: ,ds.color_method
1110: FROM bsc_kpi_analysis_measures_b an
1111: ,bsc_sys_datasets_b ds
1112: WHERE an.dataset_id = ds.dataset_id
1113: AND an.indicator = l_indicator
1114: AND NOT EXISTS (SELECT
1115: NULL from bsc_color_type_props p