APPS.IGS_EN_SUA_LGCY_PUB dependencies on IGS_PS_STDNT_UNT_TRN

Line 565: FROM igs_ps_stdnt_unt_trn

561: --
562: -- CURSOR to check if the SUA Transfer record already exists
563: CURSOR get_sua_trn IS
564: SELECT 'x'
565: FROM igs_ps_stdnt_unt_trn
566: WHERE person_id = p_person_id AND
567: course_cd = p_sua_dtls_rec.program_cd AND
568: transfer_course_cd = p_sua_dtls_rec.transfer_program_cd AND
569: transfer_dt = p_sua_dtls_rec.transfer_dt AND

Line 654: INSERT INTO igs_ps_stdnt_unt_trn (

650: FETCH get_sua_trn INTO l_dummy;
651: IF get_sua_trn%NOTFOUND THEN
652:
653: BEGIN
654: INSERT INTO igs_ps_stdnt_unt_trn (
655: PERSON_ID,
656: COURSE_CD,
657: TRANSFER_COURSE_CD,
658: TRANSFER_DT,