DBA Data[Home] [Help]

APPS.IGS_EN_GEN_013 dependencies on IGS_AS_SU_STMPTOUT

Line 220: SELECT 'x' FROM IGS_AS_SU_STMPTOUT ou, igs_en_su_attempt sua

216:
217: -- cursor to determine of a unit attempt exists which has a finalized
218: -- or un-finalised mid-term grade or an un-finalized final grade.
219: CURSOR c_sua_grade IS
220: SELECT 'x' FROM IGS_AS_SU_STMPTOUT ou, igs_en_su_attempt sua
221: where sua . person_id = p_person_id
222: and sua .course_cd = p_course_cd
223: AND sua .unit_attempt_status = 'ENROLLED'
224: AND sua.person_id = ou.person_id