APPS.IGS_AS_VAL_SUAO dependencies on IGS_EN_SU_ATTEMPT

Line 166: v_unit_attempt_status IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE;

162: cst_unconfirm CONSTANT VARCHAR2(255) := 'UNCOMFIRM';
163: cst_enrolled CONSTANT VARCHAR2(255) := 'ENROLLED';
164: cst_complete CONSTANT VARCHAR2(255) := 'COMPLETED';
165: cst_discontin CONSTANT VARCHAR2(255) := 'DISCONTIN';
166: v_unit_attempt_status IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE;
167: v_check CHAR;
168: CURSOR c_uas IS
169: SELECT unit_attempt_status
170: FROM IGS_EN_SU_ATTEMPT

Line 170: FROM IGS_EN_SU_ATTEMPT

166: v_unit_attempt_status IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE;
167: v_check CHAR;
168: CURSOR c_uas IS
169: SELECT unit_attempt_status
170: FROM IGS_EN_SU_ATTEMPT
171: WHERE person_id = p_person_id AND
172: course_cd = p_course_cd AND
173: -- anilk, 22-Apr-2003, Bug# 2829262
174: uoo_id = p_uoo_id;