DBA Data[Home] [Help]

APPS.IGS_AS_PRC_TRANSCRPT dependencies on IGS_PS_USEC_CPS

Line 661: igs_ps_usec_cps cps,

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,
663: igs_ca_inst ci
664: WHERE sut.person_id = p_person_id
665: AND sut.course_cd = p_to_course_cd

Line 1233: igs_ps_usec_cps cps,

1229: NVL (cps.enrolled_credit_points, uv.enrolled_credit_points)
1230: ) v_cp_achievable,
1231: suav.unit_attempt_status, suav.administrative_unit_status
1232: FROM igs_en_su_attempt_all suav,
1233: igs_ps_usec_cps cps,
1234: igs_ps_unit_ver uv,
1235: igs_en_stdnt_ps_att sca
1236: WHERE suav.person_id = p_person_id
1237: AND suav.course_cd = p_course_cd