222: AND category_name = cp_category
223: AND include_ind = 'Y';
224:
225: -- Cursor to find the OSS mapping values for UCAS codes
226: CURSOR cur_ucas_oss_map ( cp_association_code IGS_HE_CODE_MAP_VAL.association_code%TYPE,
227: cp_map1 IGS_HE_CODE_MAP_VAL.map1%TYPE ) IS
228: SELECT map2
229: FROM igs_he_code_map_val
230: WHERE association_code = cp_association_code
223: AND include_ind = 'Y';
224:
225: -- Cursor to find the OSS mapping values for UCAS codes
226: CURSOR cur_ucas_oss_map ( cp_association_code IGS_HE_CODE_MAP_VAL.association_code%TYPE,
227: cp_map1 IGS_HE_CODE_MAP_VAL.map1%TYPE ) IS
228: SELECT map2
229: FROM igs_he_code_map_val
230: WHERE association_code = cp_association_code
231: AND map1 = cp_map1 ;
225: -- Cursor to find the OSS mapping values for UCAS codes
226: CURSOR cur_ucas_oss_map ( cp_association_code IGS_HE_CODE_MAP_VAL.association_code%TYPE,
227: cp_map1 IGS_HE_CODE_MAP_VAL.map1%TYPE ) IS
228: SELECT map2
229: FROM igs_he_code_map_val
230: WHERE association_code = cp_association_code
231: AND map1 = cp_map1 ;
232:
233: CURSOR get_had_details (l_per_id igs_pe_person.person_id%TYPE) IS
426: FETCH c_person INTO l_person_number;
427: CLOSE c_person ;
428:
429: -----------------------------------------------------------------------------------------------------------------
430: /**** Find all the OSS mapping codes for the values to be exported to OSS from igs_he_code_map_val table ******/
431: -----------------------------------------------------------------------------------------------------------------
432:
433: /* fetch the DOMICILE CODE for the applicant */
434: l_dom_cd := NULL ;