80: ORDER BY unit_cd;
81:
82: CURSOR c_key_program(p_prog_cd VARCHAR2) IS
83: SELECT NVL(key_program,'N') , version_number, title 84: FROM igs_en_sca_v 85: WHERE COURSE_CD = p_prog_cd
86: AND PERSON_ID = p_person_id
87: ORDER BY commencement_dt DESC;
88: