DBA Data[Home] [Help]

APPS.IGS_EN_NSC_PKG dependencies on IGS_EN_SU_ATTEMPT_ALL

Line 2775: old_next_ass_ind igs_en_su_attempt_all.no_assessment_ind%TYPE;

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:

Line 2776: new_next_ass_ind igs_en_su_attempt_all.no_assessment_ind%TYPE;

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,