APPS.IGF_AW_FISAP_PKG dependencies on IGS_PS_TYPE_ALL

Line 177: FROM IGS_PS_TYPE_ALL cty,

173: RETURN VARCHAR2 IS
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;

Line 188: IGS_PS_TYPE_ALL ptype

184: CURSOR cur_earned_degrees(cp_person_id NUMBER, cp_fa_program_type VARCHAR2) IS
185: SELECT ptype.fin_aid_program_type
186: FROM IGS_AD_ACAD_HISTORY_V acadhist,
187: IGS_PS_DEGREES degree,
188: IGS_PS_TYPE_ALL ptype
189: WHERE acadhist.degree_earned = degree.degree_cd
190: AND degree.program_type = ptype.course_type
191: AND acadhist.person_id = cp_person_id
192: AND ptype.fin_aid_program_type = cp_fa_program_type;

Line 205: IGS_PS_TYPE_ALL cty,

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
209: AND crv.course_type = cty.course_type