APPS.IGS_AS_PRC_TRANSCRPT dependencies on IGS_PS_STDNT_UNT_TRN

Line 658: FROM igs_ps_stdnt_unt_trn sut,

654: ) v_cp_achieved,
655: NVL (suav.override_enrolled_cp,
656: NVL (cps.enrolled_credit_points, uv.enrolled_credit_points)
657: ) v_cp_achievable
658: FROM igs_ps_stdnt_unt_trn sut,
659: igs_ps_stdnt_trn sct,
660: igs_en_su_attempt_all suav,
661: igs_ps_usec_cps cps,
662: igs_ps_unit_ver uv,

Line 824: v_sut_course_cd IGS_PS_STDNT_UNT_TRN.transfer_course_cd%TYPE;

820: -- Transfer Date
821: DECLARE
822: v_index BINARY_INTEGER;
823: v_out_string VARCHAR2(300);
824: v_sut_course_cd IGS_PS_STDNT_UNT_TRN.transfer_course_cd%TYPE;
825: CURSOR c_sct IS
826: SELECT sct.person_id,
827: sct.transfer_course_cd,
828: sct.course_cd,

Line 841: cp_from_course_cd IGS_PS_STDNT_UNT_TRN.transfer_course_cd%TYPE) IS

837: (sct.transfer_Dt BETWEEN ci.start_dt AND ci.end_dt)
838: ORDER BY
839: sct.transfer_dt;
840: CURSOR c_sut (
841: cp_from_course_cd IGS_PS_STDNT_UNT_TRN.transfer_course_cd%TYPE) IS
842: SELECT sut.unit_cd
843: FROM IGS_PS_STDNT_UNT_TRN sut,
844: IGS_CA_INST ci
845: WHERE sut.person_id = p_person_id AND

Line 843: FROM IGS_PS_STDNT_UNT_TRN sut,

839: sct.transfer_dt;
840: CURSOR c_sut (
841: cp_from_course_cd IGS_PS_STDNT_UNT_TRN.transfer_course_cd%TYPE) IS
842: SELECT sut.unit_cd
843: FROM IGS_PS_STDNT_UNT_TRN sut,
844: IGS_CA_INST ci
845: WHERE sut.person_id = p_person_id AND
846: sut.course_cd = p_course_cd AND
847: sut.transfer_course_cd = cp_from_course_cd AND

Line 1292: FROM IGS_PS_STDNT_UNT_TRN sut

1288: cv.version_number = sca.version_number AND
1289: cv.generic_course_ind = 'N';
1290: CURSOR c_sut IS
1291: SELECT 'x'
1292: FROM IGS_PS_STDNT_UNT_TRN sut
1293: WHERE sut.person_id = p_person_id AND
1294: sut.transfer_course_cd = p_course_cd AND
1295: -- anilk, 22-Apr-2003, Bug# 2829262
1296: sut.uoo_id = p_uoo_id;

Line 2228: FROM IGS_PS_STDNT_UNT_TRN sut

2224: sua.CAL_TYPE,
2225: sua.ci_sequence_number,
2226: 'Y') = 'Y' AND
2227: NOT EXISTS ( SELECT 'x'
2228: FROM IGS_PS_STDNT_UNT_TRN sut
2229: WHERE sut.person_id = sua.person_id AND
2230: sut.transfer_course_cd = sua.course_cd AND
2231: -- anilk, 22-Apr-2003, Bug# 2829262
2232: sut.uoo_id = sua.uoo_id);