70: FROM IGS_LOOKUPS_VIEW
71: WHERE lookup_type = 'CRS_ATTEMPT_STATUS'
72: AND lookup_CODE = 'INTERMIT';
73:
74: l_load_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
75: l_load_ci_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE;
76: l_return_status VARCHAR2(10);
77: l_meaning IGS_LOOKUPS_VIEW.MEANING%TYPE;
78:
71: WHERE lookup_type = 'CRS_ATTEMPT_STATUS'
72: AND lookup_CODE = 'INTERMIT';
73:
74: l_load_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
75: l_load_ci_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE;
76: l_return_status VARCHAR2(10);
77: l_meaning IGS_LOOKUPS_VIEW.MEANING%TYPE;
78:
79: BEGIN
172: sua.ci_sequence_number,
173: ci.end_dt
174: FROM
175: IGS_EN_SU_ATTEMPT sua,
176: IGS_CA_INST ci
177: WHERE
178: sua.person_id = cp_person_id AND
179: sua.course_cd = cp_course_cd AND
180: sua.unit_attempt_status IN ('UNCONFIRM', 'ENROLLED') AND