459: cst_rejected,
460: cst_lapsed,
461: cst_deferral));
462:
463: CURSOR c_term (cp_person_id igs_en_spa_terms.person_id%TYPE,
464: cp_course_cd igs_en_spa_terms.program_cd%TYPE) IS
465: SELECT sterm.person_id,sterm.program_cd
466: FROM IGS_EN_SPA_TERMS sterm
467: WHERE sterm.person_id = cp_person_id
460: cst_lapsed,
461: cst_deferral));
462:
463: CURSOR c_term (cp_person_id igs_en_spa_terms.person_id%TYPE,
464: cp_course_cd igs_en_spa_terms.program_cd%TYPE) IS
465: SELECT sterm.person_id,sterm.program_cd
466: FROM IGS_EN_SPA_TERMS sterm
467: WHERE sterm.person_id = cp_person_id
468: AND sterm.program_cd = cp_course_cd;
462:
463: CURSOR c_term (cp_person_id igs_en_spa_terms.person_id%TYPE,
464: cp_course_cd igs_en_spa_terms.program_cd%TYPE) IS
465: SELECT sterm.person_id,sterm.program_cd
466: FROM IGS_EN_SPA_TERMS sterm
467: WHERE sterm.person_id = cp_person_id
468: AND sterm.program_cd = cp_course_cd;
469:
470: l_term c_term%ROWTYPE;