eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.IGS_AS_SU_STMPTOUT_PKG dependencies on IGS_EN_SU_ATTEMPT_ALL

Line 387: FROM igs_en_su_attempt_all sua

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'
387: FROM igs_en_su_attempt_all sua
388: WHERE sua.person_id = sut1.person_id
389: AND sua.course_cd = sut1.transfer_course_cd
390: AND sua.uoo_id = sut1.uoo_id
391: AND sua.unit_attempt_status IN ('COMPLETED', 'DISCONTIN')

Line 393: FROM igs_en_su_attempt_all sua

389: AND sua.course_cd = sut1.transfer_course_cd
390: AND sua.uoo_id = sut1.uoo_id
391: AND sua.unit_attempt_status IN ('COMPLETED', 'DISCONTIN')
392: AND EXISTS (SELECT 'X'
393: FROM igs_en_su_attempt_all sua
394: WHERE sua.person_id = sut1.person_id
395: AND sua.course_cd = sut1.course_cd
396: AND sua.uoo_id = sut1.uoo_id
397: AND sua.unit_attempt_status = 'DUPLICATE'))