APPS.IGS_SS_ENROLL_PKG dependencies on IGS_PS_STDNT_UNT_TRN

Line 931: FROM igs_ps_stdnt_unt_trn sut,

927: --
928: -------------------------------------------------------------------
929: CURSOR cur_src_unit_atmpt IS
930: SELECT sut.transfer_course_cd
931: FROM igs_ps_stdnt_unt_trn sut,
932: igs_en_su_attempt sua
933: WHERE sut.person_id = p_person_id
934: AND sua.person_id = sut.person_id
935: AND sut.uoo_id = p_uoo_id

Line 940: l_c_transfer_course_cd igs_ps_stdnt_unt_trn.transfer_course_cd%TYPE;

936: AND sua.uoo_id = sut.uoo_id
937: AND sua.course_cd = sut.transfer_course_cd
938: AND sut.course_cd = p_course_cd
939: ORDER BY sut.transfer_dt desc;
940: l_c_transfer_course_cd igs_ps_stdnt_unt_trn.transfer_course_cd%TYPE;
941:
942: BEGIN
943: OPEN cur_src_unit_atmpt;
944: FETCH cur_src_unit_atmpt INTO l_c_transfer_course_cd;

Line 1084: FROM igs_ps_stdnt_unt_trn

1080: --
1081: -------------------------------------------------------------------
1082: CURSOR cur_src_prg IS
1083: SELECT transfer_course_cd
1084: FROM igs_ps_stdnt_unt_trn
1085: WHERE person_id = p_person_id
1086: AND course_cd = p_program_cd
1087: AND uoo_id = p_uoo_id;
1088: l_c_transfer_course_cd igs_ps_stdnt_unt_trn.transfer_course_cd%TYPE;

Line 1088: l_c_transfer_course_cd igs_ps_stdnt_unt_trn.transfer_course_cd%TYPE;

1084: FROM igs_ps_stdnt_unt_trn
1085: WHERE person_id = p_person_id
1086: AND course_cd = p_program_cd
1087: AND uoo_id = p_uoo_id;
1088: l_c_transfer_course_cd igs_ps_stdnt_unt_trn.transfer_course_cd%TYPE;
1089:
1090: CURSOR cur_prg_atmpt(cp_program_cd igs_en_stdnt_ps_att.course_cd%TYPE) IS
1091: SELECT course_type
1092: FROM igs_en_stdnt_ps_att sca,