APPS.IGS_RE_VAL_TEX dependencies on IGS_EN_SPA_AWD_AIM

Line 211: FROM igs_en_spa_awd_aim

207: thr.s_thesis_result_cd <> cst_no_result;
208: CURSOR c_awd_exists(cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
209: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE) IS
210: SELECT 'x'
211: FROM igs_en_spa_awd_aim
212: WHERE person_id = cp_person_id
213: AND course_cd = cp_course_cd
214: AND ( end_dt IS NULL OR
215: (end_dt IS NOT NULL AND complete_ind = 'Y')

Line 220: FROM igs_en_spa_awd_aim

216: );
217: CURSOR c_incomp_awd(cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
218: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE) IS
219: SELECT 'x'
220: FROM igs_en_spa_awd_aim
221: WHERE person_id = cp_person_id
222: AND course_cd = cp_course_cd
223: AND NVL(complete_ind,'N') = 'N'
224: AND end_dt IS NULL;