APPS.IGS_EN_NSC_PKG dependencies on IGS_EN_SU_ATTEMPT_H

Line 2726: FROM igs_en_su_attempt_h ut,

2722: ut.uoo_id,
2723: ut.administrative_unit_status,
2724: ut.unit_attempt_status,
2725: ut.discontinued_dt
2726: FROM igs_en_su_attempt_h ut,
2727: igs_en_stdnt_ps_att pr,
2728: igs_ps_ver vers
2729: WHERE ut.cal_type = p_teach_cal_type
2730: AND ut.ci_sequence_number = p_teach_ci_sequence_number

Line 2756: FROM igs_en_su_attempt_h ut

2752: ut.administrative_unit_status,
2753: ut.unit_attempt_status,
2754: ut.no_assessment_ind,
2755: ut.hist_end_dt
2756: FROM igs_en_su_attempt_h ut
2757: WHERE ut.person_id = p_student_id
2758: AND ut.course_cd = p_c_course_cd
2759: AND ut.uoo_id = p_c_uoo_id
2760: AND ut.hist_end_dt > p_c_hist_end_dt

Line 2762: old_hist_end_dt igs_en_su_attempt_h.hist_end_dt%TYPE;

2758: AND ut.course_cd = p_c_course_cd
2759: AND ut.uoo_id = p_c_uoo_id
2760: AND ut.hist_end_dt > p_c_hist_end_dt
2761: ORDER BY ut.hist_end_dt;
2762: old_hist_end_dt igs_en_su_attempt_h.hist_end_dt%TYPE;
2763: -- get the next history record whose assessment_ind is not null
2764: CURSOR c_next_ass_ind (p_c_course_cd VARCHAR2,
2765: p_c_uoo_id NUMBER,
2766: p_c_hist_end_dt DATE ) IS

Line 2768: FROM igs_en_su_attempt_h ut

2764: CURSOR c_next_ass_ind (p_c_course_cd VARCHAR2,
2765: p_c_uoo_id NUMBER,
2766: p_c_hist_end_dt DATE ) IS
2767: SELECT ut.no_assessment_ind
2768: FROM igs_en_su_attempt_h ut
2769: WHERE ut.person_id = p_student_id
2770: AND ut.course_cd = p_c_course_cd
2771: AND ut.uoo_id = p_c_uoo_id
2772: AND ut.hist_end_dt > p_c_hist_end_dt