APPS.IGS_HE_VERIFY_RETURN_PKG dependencies on IGS_EN_SU_ATTEMPT_ALL

Line 386: FROM igs_en_su_attempt_all

382: CURSOR c_enr_su (p_person_id igs_en_stdnt_ps_att_all.person_id%TYPE,
383: p_course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE,
384: p_enrolment_end_date igs_he_submsn_header.enrolment_end_date%TYPE) IS
385: SELECT 'X'
386: FROM igs_en_su_attempt_all
387: WHERE person_id = p_person_id
388: AND course_cd = p_course_cd
389: AND unit_attempt_status IN ('ENROLLED', 'COMPLETED','DISCONTIN','DUPLICATE')
390: AND enrolled_dt <= p_enrolment_end_date;

Line 713: FROM igs_en_su_attempt_all ua,

709: (SELECT DISTINCT
710: ua.unit_cd,
711: ua.version_number,
712: DECODE(hunt.hesa_st_unt_vs_id, NULL, 'N', 'Y') unit_flag, sysdate, 1, sysdate, 1
713: FROM igs_en_su_attempt_all ua,
714: igs_he_verify_data_t t,
715: igs_he_st_unt_vs_all hunt
716: WHERE t.person_id = ua.person_id
717: AND ua.unit_cd = hunt.unit_cd (+)

Line 727: FROM igs_en_su_attempt_all ua,

723: SELECT DISTINCT
724: ua.unit_cd,
725: ua.version_number,
726: DECODE(hunt.hesa_st_unt_vs_id, NULL, 'N', 'Y') unit_flag, sysdate, 1, sysdate, 1
727: FROM igs_en_su_attempt_all ua,
728: igs_he_verify_data_t t,
729: igs_he_st_unt_vs_all hunt,
730: igs_as_su_stmptout_all uao
731: WHERE t.person_id = ua.person_id