DBA Data[Home] [Help]

APPS.IGF_AW_FISAP_PKG dependencies on IGS_EN_STDNT_PS_ATT_ALL

Line 197: FROM IGS_EN_STDNT_PS_ATT_ALL

193: rec_earned_degrees cur_earned_degrees%ROWTYPE;
194:
195: CURSOR cur_completed_prog(cp_person_id IN NUMBER) IS
196: SELECT course_cd
197: FROM IGS_EN_STDNT_PS_ATT_ALL
198: WHERE course_attempt_status = 'COMPLETED'
199: AND person_id = cp_person_id;
200: rec_completed_prog cur_completed_prog%ROWTYPE;
201:

Line 204: FROM IGS_EN_STDNT_PS_ATT_ALL statt,

200: rec_completed_prog cur_completed_prog%ROWTYPE;
201:
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