APPS.IGS_EN_SU_ATTEMPT_PKG dependencies on IGS_PS_STDNT_UNT_TRN

Line 1731: IGS_PS_STDNT_UNT_TRN_PKG.GET_FK_IGS_EN_SU_ATTEMPT (

1727: old_references.person_id,
1728: old_references.course_cd,
1729: old_references.uoo_id
1730: );
1731: IGS_PS_STDNT_UNT_TRN_PKG.GET_FK_IGS_EN_SU_ATTEMPT (
1732: old_references.person_id,
1733: old_references.course_cd,
1734: old_references.uoo_id
1735: );

Line 2480: FROM IGS_PS_STDNT_UNT_TRN sut

2476: AND uoo_id=cp_uoo_id
2477: AND unit_attempt_status ='COMPLETED'
2478: AND course_cd <> cp_course_cd
2479: AND EXISTS (SELECT 'x'
2480: FROM IGS_PS_STDNT_UNT_TRN sut
2481: WHERE sut.person_id = cp_person_id
2482: AND sut.uoo_id = cp_uoo_id
2483: AND sut.transfer_course_cd = cp_course_cd
2484: AND sut.course_cd = sua.course_cd

Line 2502: FROM IGS_PS_STDNT_UNT_TRN sut

2498: AND unit_attempt_status IN ('ENROLLED','DUPLICATE','COMPLETED','DISCONTIN')
2499: AND (
2500: (course_cd <> cp_course_cd
2501: AND NOT EXISTS (SELECT 'x'
2502: FROM IGS_PS_STDNT_UNT_TRN sut
2503: WHERE sut.person_id = cp_person_id
2504: and sut.uoo_id = cp_uoo_id
2505: AND sut.transfer_course_cd = sua.course_cd
2506: AND sut.course_cd = cp_course_cd)