APPS.IGS_EN_GEN_007 dependencies on IGS_PS_STDNT_UNT_TRN

Line 343: FROM IGS_PS_STDNT_UNT_TRN sut1, IGS_EN_SU_ATTEMPT sua

339: grading_period_cd = cst_grading_period_cd
340: );
341: CURSOR c_sut IS
342: SELECT sua.unit_attempt_status
343: FROM IGS_PS_STDNT_UNT_TRN sut1, IGS_EN_SU_ATTEMPT sua
344: WHERE sut1.person_id = p_person_id AND
345: sut1.course_cd = p_course_cd AND
346: sua.person_id = sut1.person_id AND
347: sua.course_cd = sut1.transfer_course_cd AND

Line 351: FROM IGS_PS_STDNT_UNT_TRN sut2

347: sua.course_cd = sut1.transfer_course_cd AND
348: sua.uoo_id = sut1.uoo_id AND
349: sut1.uoo_id = p_uoo_id AND
350: sut1.transfer_dt = ( SELECT max(sut2.transfer_dt)
351: FROM IGS_PS_STDNT_UNT_TRN sut2
352: where sut2.person_id = sut1.person_id
353: and sut2.course_cd = sut1.course_cd
354: and sut2.uoo_id = sut1.uoo_id)
355: AND sut1.transfer_dt > (SELECT NVL(max(sut3.transfer_dt),(sut1.transfer_dt-1))

Line 356: FROM IGS_PS_STDNT_UNT_TRN sut3

352: where sut2.person_id = sut1.person_id
353: and sut2.course_cd = sut1.course_cd
354: and sut2.uoo_id = sut1.uoo_id)
355: AND sut1.transfer_dt > (SELECT NVL(max(sut3.transfer_dt),(sut1.transfer_dt-1))
356: FROM IGS_PS_STDNT_UNT_TRN sut3
357: where sut3.person_id = sut1.person_id
358: and sut3.transfer_course_cd = sut1.course_cd
359: and sut3.uoo_id = sut1.uoo_id);
360: v_sut_rec c_sut%ROWTYPE;

Line 405: -- Status is duplicate if IGS_PS_STDNT_UNT_TRN detail exists

401: -- Status is unconfirmed if enrolled date is not set
402: IF v_enrolled_dt IS NULL THEN
403: RETURN cst_unconfirm;
404: END IF;
405: -- Status is duplicate if IGS_PS_STDNT_UNT_TRN detail exists
406: IF v_unit_attempt_status IN (cst_completed,cst_discontin, cst_duplicate) THEN
407: OPEN c_sut;
408: FETCH c_sut INTO v_sut_rec;
409: IF c_sut%FOUND THEN