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.IGF_AW_FISAP_PKG dependencies on IGS_PS_VER

Line 111: FROM IGS_PS_VER_V

107: RETURN BOOLEAN IS
108:
109: CURSOR cur_fa_program(cp_course_cd IN VARCHAR2, cp_version_number IN NUMBER) IS
110: SELECT federal_financial_aid
111: FROM IGS_PS_VER_V
112: WHERE course_cd = cp_course_cd
113: AND version_number = cp_version_number;
114: rec_fa_program cur_fa_program%ROWTYPE;
115:

Line 178: IGS_PS_VER crv

174:
175: CURSOR cur_fa_prog_type(cp_course_cd IN VARCHAR2, cp_version_number IN NUMBER) IS
176: SELECT cty.fin_aid_program_type
177: FROM IGS_PS_TYPE_ALL cty,
178: IGS_PS_VER crv
179: WHERE crv.course_type = cty.course_type
180: AND crv.course_cd = cp_course_cd
181: AND crv.version_number = cp_version_number;
182: rec_fa_prog_type cur_fa_prog_type%ROWTYPE;

Line 206: IGS_PS_VER crv

202: CURSOR cur_completed_ugprog(cp_person_id NUMBER, cp_fa_program_type VARCHAR2) IS
203: SELECT cty.fin_aid_program_type
204: FROM IGS_EN_STDNT_PS_ATT_ALL statt,
205: IGS_PS_TYPE_ALL cty,
206: IGS_PS_VER crv
207: WHERE crv.course_cd = statt.course_cd
208: AND crv.version_number = statt.version_number
209: AND crv.course_type = cty.course_type
210: AND statt.course_attempt_status = 'COMPLETED'