APPS.IGS_EN_VAL_SUA dependencies on IGS_PS_STDNT_UNT_TRN

Line 634: FROM IGS_PS_STDNT_UNT_TRN sut1

630: -- unit_attempt_status.
631: DECLARE
632: CURSOR c_sut IS
633: SELECT 'X'
634: FROM IGS_PS_STDNT_UNT_TRN sut1
635: WHERE
636: sut1.person_id = p_person_id AND
637: sut1.transfer_course_cd = p_course_cd AND
638: sut1.uoo_id = p_uoo_id and

Line 640: FROM IGS_PS_STDNT_UNT_TRN sut2

636: sut1.person_id = p_person_id AND
637: sut1.transfer_course_cd = p_course_cd AND
638: sut1.uoo_id = p_uoo_id and
639: sut1.transfer_dt = ( SELECT max(sut2.transfer_dt)
640: FROM IGS_PS_STDNT_UNT_TRN sut2
641: where sut2.person_id = sut1.person_id
642: and sut2.transfer_course_cd = sut1.transfer_course_cd
643: and sut2.uoo_id = sut1.uoo_id)
644: and sut1.transfer_dt > (SELECT NVL(max(sut3.transfer_dt),(sut1.transfer_dt-1))

Line 645: FROM IGS_PS_STDNT_UNT_TRN sut3

641: where sut2.person_id = sut1.person_id
642: and sut2.transfer_course_cd = sut1.transfer_course_cd
643: and sut2.uoo_id = sut1.uoo_id)
644: and sut1.transfer_dt > (SELECT NVL(max(sut3.transfer_dt),(sut1.transfer_dt-1))
645: FROM IGS_PS_STDNT_UNT_TRN sut3
646: where sut3.person_id = sut1.person_id
647: and sut3.course_cd = sut1.transfer_course_cd
648: and sut3.uoo_id = sut1.uoo_id);
649: CURSOR c_sca IS

Line 2150: FROM IGS_PS_STDNT_UNT_TRN

2146: v_course_rqrmnt_complete_ind
2147: IGS_EN_STDNT_PS_ATT.course_rqrmnt_complete_ind%TYPE := NULL;
2148: CURSOR c_sut IS
2149: SELECT 'x'
2150: FROM IGS_PS_STDNT_UNT_TRN
2151: WHERE person_id = p_person_id AND
2152: transfer_course_cd = p_course_cd AND
2153: uoo_id = p_uoo_id;
2154: v_sut_found VARCHAR2(1) := NULL;