DBA Data[Home] [Help]

APPS.IGS_AS_GEN_007 dependencies on IGS_EN_SU_ATTEMPT_ALL

Line 854: igs_en_su_attempt_all sua,

850: st.todo_dt,
851: sua.uoo_id
852: FROM igs_pe_std_todo st,
853: igs_pe_std_todo_ref str,
854: igs_en_su_attempt_all sua,
855: igs_as_unit_class uc,
856: igs_ca_inst_rel cir
857: WHERE ((NVL (p_person_id, 9999999999) = 9999999999)
858: OR (st.person_id = p_person_id)

Line 1599: FROM igs_en_su_attempt_all sua

1595: AND (suaai.unit_section_ass_item_id = v_uai_rec.ass_item_id
1596: OR suaai.unit_ass_item_id = v_uai_rec.ass_item_id)
1597: AND EXISTS (
1598: SELECT 'X'
1599: FROM igs_en_su_attempt_all sua
1600: WHERE sua.person_id = suaai.person_id
1601: AND sua.course_cd = suaai.course_cd
1602: AND sua.uoo_id = suaai.uoo_id
1603: AND sua.unit_attempt_status IN ('ENROLLED', 'UNCONFIRM', 'WAITLISTED')