DBA Data[Home] [Help]

APPS.IGS_HE_EXTRACT_PKG dependencies on IGS_EN_SU_ATTEMPT_ALL

Line 1224: FROM igs_en_su_attempt_all

1220: CURSOR c_enr_su (p_person_id igs_en_stdnt_ps_att_all.person_id%TYPE,
1221: p_course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE,
1222: p_enrolment_end_date igs_he_submsn_header.enrolment_end_date%TYPE) IS
1223: SELECT 'X'
1224: FROM igs_en_su_attempt_all
1225: WHERE person_id = p_person_id
1226: AND course_cd = p_course_cd
1227: AND unit_attempt_status IN ('ENROLLED', 'COMPLETED','DISCONTIN','DUPLICATE')
1228: AND TRUNC(enrolled_dt) <= p_enrolment_end_date;