APPS.IGS_AS_SU_STMPTOUT_PKG dependencies on IGS_PS_STDNT_UNT_TRN

Line 382: FROM igs_ps_stdnt_unt_trn sut1

378: cp_course_cd IN VARCHAR2,
379: cp_uoo_id IN VARCHAR2
380: ) IS
381: SELECT 'Y' transfer_exists
382: FROM igs_ps_stdnt_unt_trn sut1
383: WHERE sut1.person_id = cp_person_id
384: AND sut1.transfer_course_cd = cp_course_cd
385: AND sut1.uoo_id = cp_uoo_id
386: AND EXISTS ( SELECT 'X'

Line 399: FROM igs_ps_stdnt_unt_trn sut2

395: AND sua.course_cd = sut1.course_cd
396: AND sua.uoo_id = sut1.uoo_id
397: AND sua.unit_attempt_status = 'DUPLICATE'))
398: AND sut1.transfer_dt = (SELECT MAX (sut2.transfer_dt)
399: FROM igs_ps_stdnt_unt_trn sut2
400: WHERE sut2.person_id = sut1.person_id
401: AND sut2.transfer_course_cd = sut1.transfer_course_cd
402: AND sut2.uoo_id = sut1.uoo_id)
403: AND sut1.transfer_dt > (SELECT NVL (MAX (sut3.transfer_dt),( sut1.transfer_dt - 1))

Line 404: FROM igs_ps_stdnt_unt_trn sut3

400: WHERE sut2.person_id = sut1.person_id
401: AND sut2.transfer_course_cd = sut1.transfer_course_cd
402: AND sut2.uoo_id = sut1.uoo_id)
403: AND sut1.transfer_dt > (SELECT NVL (MAX (sut3.transfer_dt),( sut1.transfer_dt - 1))
404: FROM igs_ps_stdnt_unt_trn sut3
405: WHERE sut3.person_id = sut1.person_id
406: AND sut3.course_cd = sut1.transfer_course_cd
407: AND sut3.uoo_id = sut1.uoo_id);
408: --