585: AND p_appno BETWEEN appno_first AND appno_maximum;
586:
587:
588: -- To get the OSS eqvivalent value for UCAS Value.
589: CURSOR cur_map (p_assoc igs_he_code_map_val.association_code%TYPE ,
590: p_map1 igs_he_code_map_val.map1%TYPE ) IS
591: SELECT map2
592: FROM igs_he_code_map_val
593: WHERE association_code = p_assoc
586:
587:
588: -- To get the OSS eqvivalent value for UCAS Value.
589: CURSOR cur_map (p_assoc igs_he_code_map_val.association_code%TYPE ,
590: p_map1 igs_he_code_map_val.map1%TYPE ) IS
591: SELECT map2
592: FROM igs_he_code_map_val
593: WHERE association_code = p_assoc
594: AND map1 = p_map1;
588: -- To get the OSS eqvivalent value for UCAS Value.
589: CURSOR cur_map (p_assoc igs_he_code_map_val.association_code%TYPE ,
590: p_map1 igs_he_code_map_val.map1%TYPE ) IS
591: SELECT map2
592: FROM igs_he_code_map_val
593: WHERE association_code = p_assoc
594: AND map1 = p_map1;
595:
596: -- TITLE validation