1432: -- This module determines if the student IGS_PS_COURSE attenmpt has been transferred
1433: --This is determined by the existence of one or nore student IGS_PS_COURSE transfer
1434: -- details where the latest is a transfer 'from' the IGS_PS_COURSE attempt
1435: DECLARE
1436: v_trnsfr_crs_cd IGS_PS_STDNT_TRN.transfer_course_cd%TYPE;
1437: CURSOR c_sct IS
1438: SELECT sct.transfer_course_cd
1439: FROM IGS_PS_STDNT_TRN sct
1440: WHERE sct.person_id = p_person_id AND
1435: DECLARE
1436: v_trnsfr_crs_cd IGS_PS_STDNT_TRN.transfer_course_cd%TYPE;
1437: CURSOR c_sct IS
1438: SELECT sct.transfer_course_cd
1439: FROM IGS_PS_STDNT_TRN sct
1440: WHERE sct.person_id = p_person_id AND
1441: (sct.course_cd = p_course_cd OR
1442: sct.transfer_course_cd = p_course_cd)
1443: ORDER BY transfer_dt desc;