822: AND bis_ind.measure_type = 'CDS_CALC';
823:
824: CURSOR c_region_obj(p_region_code VARCHAR2) IS
825: SELECT attribute8
826: FROM ak_regions
827: WHERE region_code = p_region_code
828: AND attribute10 = 'BSC_DATA_SOURCE'
829: AND attribute8 IS NOT NULL;
830:
827: WHERE region_code = p_region_code
828: AND attribute10 = 'BSC_DATA_SOURCE'
829: AND attribute8 IS NOT NULL;
830:
831: l_region_code AK_REGIONS.region_code%TYPE;
832: l_attribute8 AK_REGIONS.attribute8%TYPE;
833: l_objective_id NUMBER;
834: l_anal_opt_rec BSC_ANALYSIS_OPTION_PUB.bsc_option_rec_type;
835: x_anal_opt_rec BSC_ANALYSIS_OPTION_PUB.bsc_option_rec_type;
828: AND attribute10 = 'BSC_DATA_SOURCE'
829: AND attribute8 IS NOT NULL;
830:
831: l_region_code AK_REGIONS.region_code%TYPE;
832: l_attribute8 AK_REGIONS.attribute8%TYPE;
833: l_objective_id NUMBER;
834: l_anal_opt_rec BSC_ANALYSIS_OPTION_PUB.bsc_option_rec_type;
835: x_anal_opt_rec BSC_ANALYSIS_OPTION_PUB.bsc_option_rec_type;
836: x_return_status VARCHAR2(1);