APPS.BSC_UPDATE_UTIL dependencies on BSC_SYS_DATASETS_B

Line 6267: bsc_sys_datasets_b ds,

6263: NULL, NULL,
6264: m2.operation || '(' || NVL(BSC_APPS.Get_Property_Value(m2.s_color_formula, 'pFormulaSource'), m2.measure_col) || ')' ) measure_formula
6265: FROM bsc_tab_indicators tab_ind,
6266: bsc_kpi_analysis_measures_b anal_meas,
6267: bsc_sys_datasets_b ds,
6268: bsc_sys_measures m1,
6269: bsc_sys_measures m2,
6270: bsc_kpis_b obj
6271: WHERE anal_meas.dataset_id = ds.dataset_id

Line 6315: FROM bsc_sys_datasets_b dts,

6311: IS
6312: CURSOR c_kpi_source(p_indicator NUMBER, p_kpi_measure NUMBER) IS
6313: SELECT ind.measure_type source,
6314: dts.dataset_id
6315: FROM bsc_sys_datasets_b dts,
6316: bis_indicators ind,
6317: bsc_kpi_analysis_measures_b am
6318: WHERE dts.dataset_id = am.dataset_id
6319: AND dts.dataset_id = ind.dataset_id

Line 6324: l_source bsc_sys_datasets_b.source%TYPE;

6320: AND am.indicator = p_indicator
6321: AND am.kpi_measure_id = p_kpi_measure;
6322: l_kpi_source_rec c_kpi_source%ROWTYPE;
6323:
6324: l_source bsc_sys_datasets_b.source%TYPE;
6325: l_default_node_dataset_id bsc_sys_datasets_b.dataset_id%TYPE;
6326: l_measure_formula VARCHAR2(4000);
6327:
6328: BEGIN

Line 6325: l_default_node_dataset_id bsc_sys_datasets_b.dataset_id%TYPE;

6321: AND am.kpi_measure_id = p_kpi_measure;
6322: l_kpi_source_rec c_kpi_source%ROWTYPE;
6323:
6324: l_source bsc_sys_datasets_b.source%TYPE;
6325: l_default_node_dataset_id bsc_sys_datasets_b.dataset_id%TYPE;
6326: l_measure_formula VARCHAR2(4000);
6327:
6328: BEGIN
6329: