eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.IGS_AS_PRC_TRANSCRPT dependencies on IGS_PS_UNIT_VER

Line 662: igs_ps_unit_ver uv,

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
666: AND sut.person_id = sct.person_id

Line 1234: igs_ps_unit_ver uv,

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
1238: AND sca.person_id = suav.person_id

Line 1676: IGS_PS_UNIT_VER uv

1672: uv.short_title,
1673: uv.TITLE,
1674: uv.UNIT_LEVEL
1675: FROM IGS_AV_STND_UNIT asu,
1676: IGS_PS_UNIT_VER uv
1677: WHERE asu.person_id = p_person_id AND
1678: asu.as_course_cd = p_course_cd AND
1679: asu.s_adv_stnd_granting_status = 'GRANTED' AND
1680: asu.s_adv_stnd_recognition_type = 'CREDIT' AND