[Home] [Help]
2114: AND ucrvop.keyword = p_keyword
2115: AND ucrvop.system_code = p_system;
2116:
2117: -- validate the the UCAS program details are valid i.e exist in Course details table.
2118: CURSOR validate_crse_cur (p_course igs_uc_ucrsvac_ints.course%TYPE, p_campus igs_uc_ucrsvac_ints.campus%TYPE,
2119: p_system igs_uc_crse_dets.system_code%TYPE) IS
2120: SELECT ucrdet.rowid
2121: FROM igs_uc_crse_dets ucrdet
2122: WHERE ucrdet.ucas_program_code = p_course