15: BEGIN
16: DECLARE
17: -- cursor to get the current student course attempt status
18: CURSOR c_sca (
19: cp_column_name user_tab_columns.column_name%TYPE,
20: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
21: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE) IS
22: SELECT /*+ ROWID(IGS_EN_STDNT_PS_ATT) */
23: course_attempt_status,
57: WHERE person_id = cp_person_id AND
58: course_cd = cp_course_cd;
59: -- cursor to get the last enrolled history
60: CURSOR c_last_e_scah (
61: cp_column_name user_tab_columns.column_name%TYPE,
62: cp_person_id IGS_AS_SC_ATTEMPT_H.person_id%TYPE,
63: cp_course_cd IGS_AS_SC_ATTEMPT_H.course_cd%TYPE) IS
64: SELECT /*+ FIRST_ROWS */
65: hist_start_dt,