[Home] [Help]
2771: AND ut.uoo_id = p_c_uoo_id
2772: AND ut.hist_end_dt > p_c_hist_end_dt
2773: AND ut.no_assessment_ind IS NOT NULL
2774: ORDER BY ut.hist_end_dt;
2775: old_next_ass_ind igs_en_su_attempt_all.no_assessment_ind%TYPE;
2776: new_next_ass_ind igs_en_su_attempt_all.no_assessment_ind%TYPE;
2777:
2778: -- This cursor selects current record to compare enrollment points.
2779:
2772: AND ut.hist_end_dt > p_c_hist_end_dt
2773: AND ut.no_assessment_ind IS NOT NULL
2774: ORDER BY ut.hist_end_dt;
2775: old_next_ass_ind igs_en_su_attempt_all.no_assessment_ind%TYPE;
2776: new_next_ass_ind igs_en_su_attempt_all.no_assessment_ind%TYPE;
2777:
2778: -- This cursor selects current record to compare enrollment points.
2779:
2780: CURSOR c_orig_units(p_c_course_cd VARCHAR2,