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.

APPS.IGS_AS_VAL_SCAP dependencies on IGS_AS_UAI_SUA_V

Line 103: v_person_id IGS_AS_UAI_SUA_V.person_id%TYPE;

99: BEGIN
100: DECLARE
101: v_attempt_status IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE;
102: l_uoo_id igs_en_su_attempt.uoo_id%TYPE;
103: v_person_id IGS_AS_UAI_SUA_V.person_id%TYPE;
104: cst_unconfirm CONSTANT IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE :=
105: 'UNCONFIRM';
106: cst_enrolled CONSTANT IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE :=
107: 'ENROLLED';

Line 119: FROM IGS_AS_UAI_SUA_V suv

115: -- anilk, 22-Apr-2003, Bug# 2829262
116: sua.uoo_id = p_uoo_id;
117: CURSOR c_suv IS
118: SELECT suv.person_id
119: FROM IGS_AS_UAI_SUA_V suv
120: WHERE suv.person_id = p_person_id AND
121: suv.course_cd = p_course_cd AND
122: -- anilk, 22-Apr-2003, Bug# 2829262
123: suv.uoo_id = p_uoo_id AND