DBA Data[Home] [Help]

APPS.IGS_EN_STDNT_PS_ATT_PKG dependencies on IGS_EN_SU_ATTEMPT_ALL

Line 3059: CURSOR cur_sua_uooid(cp_person_id igs_en_su_attempt_all.person_id%TYPE, cp_course_cd igs_en_su_attempt_all.course_cd%TYPE)

3055: spa.version_number = pv.version_number AND
3056: pv.course_type = cp_course_type;
3057: cur_pattempts_rec cur_pattempts%ROWTYPE;
3058:
3059: CURSOR cur_sua_uooid(cp_person_id igs_en_su_attempt_all.person_id%TYPE, cp_course_cd igs_en_su_attempt_all.course_cd%TYPE)
3060: IS
3061: SELECT sua.uoo_id
3062: FROM igs_en_su_attempt_all sua
3063: WHERE sua.person_id = cp_person_id AND

Line 3062: FROM igs_en_su_attempt_all sua

3058:
3059: CURSOR cur_sua_uooid(cp_person_id igs_en_su_attempt_all.person_id%TYPE, cp_course_cd igs_en_su_attempt_all.course_cd%TYPE)
3060: IS
3061: SELECT sua.uoo_id
3062: FROM igs_en_su_attempt_all sua
3063: WHERE sua.person_id = cp_person_id AND
3064: sua.course_cd = cp_course_cd AND
3065: sua.unit_attempt_status = 'UNCONFIRM';
3066: cur_sua_uooid_rec cur_sua_uooid%ROWTYPE;