APPS.BSC_OBJ_ANALYSIS_OPTIONS_PUB dependencies on BSC_SYS_DATASETS_B

Line 842: bsc_sys_datasets_b ds

838: BULK COLLECT INTO
839: x_dim_Dataset_map
840: FROM
841: bsc_db_dataset_dim_sets_v dim,
842: bsc_sys_datasets_b ds
843: WHERE
844: dim.indicator = p_Indicator AND
845: dim.dataset_id = ds.dataset_id AND
846: ds.source = 'BSC'

Line 3202: bsc_sys_datasets_b ds

3198: BULK COLLECT INTO
3199: l_olddim_Dataset_map
3200: FROM
3201: bsc_db_dataset_dim_sets_v dim,
3202: bsc_sys_datasets_b ds
3203: WHERE
3204: dim.indicator = p_Indicator AND
3205: dim.dataset_id = ds.dataset_id AND
3206: ds.source = 'BSC'

Line 3698: l_dataset_id bsc_sys_datasets_b.dataset_id%TYPE;

3694: l_Next_Group_Id NUMBER;
3695: l_AO0 bsc_kpi_analysis_measures_b.analysis_option0%TYPE := 0;
3696: l_AO1 bsc_kpi_analysis_measures_b.analysis_option1%TYPE := 0;
3697: l_AO2 bsc_kpi_analysis_measures_b.analysis_option2%TYPE := 0;
3698: l_dataset_id bsc_sys_datasets_b.dataset_id%TYPE;
3699: -- l_source bsc_sys_datasets_b.source%TYPE;
3700:
3701: BEGIN
3702: OPEN c_Indicator_Type;

Line 3699: -- l_source bsc_sys_datasets_b.source%TYPE;

3695: l_AO0 bsc_kpi_analysis_measures_b.analysis_option0%TYPE := 0;
3696: l_AO1 bsc_kpi_analysis_measures_b.analysis_option1%TYPE := 0;
3697: l_AO2 bsc_kpi_analysis_measures_b.analysis_option2%TYPE := 0;
3698: l_dataset_id bsc_sys_datasets_b.dataset_id%TYPE;
3699: -- l_source bsc_sys_datasets_b.source%TYPE;
3700:
3701: BEGIN
3702: OPEN c_Indicator_Type;
3703: FETCH c_Indicator_Type INTO l_Indicator_Type;

Line 4232: l_kpi_measure_id bsc_sys_datasets_b.dataset_id%TYPE;

4228: l_Next_Group_Id NUMBER;
4229: l_AO0 bsc_kpi_analysis_measures_b.analysis_option0%TYPE := 0;
4230: l_AO1 bsc_kpi_analysis_measures_b.analysis_option1%TYPE := 0;
4231: l_AO2 bsc_kpi_analysis_measures_b.analysis_option2%TYPE := 0;
4232: l_kpi_measure_id bsc_sys_datasets_b.dataset_id%TYPE;
4233: l_Property_Value NUMBER;
4234:
4235: BEGIN
4236: OPEN c_Indicator_Type;