APPS.IGS_RE_VAL_CAH dependencies on IGS_EN_SPA_AWD_AIM

Line 165: FROM igs_en_spa_awd_aim

161: sca.course_cd = cp_sca_course_cd;
162: CURSOR c_awd_exists(cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
163: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE) IS
164: SELECT 'x'
165: FROM igs_en_spa_awd_aim
166: WHERE person_id = cp_person_id
167: AND course_cd = cp_course_cd
168: AND ( end_dt IS NULL OR
169: (end_dt IS NOT NULL AND complete_ind = 'Y')

Line 174: FROM igs_en_spa_awd_aim

170: );
171: CURSOR c_incomp_awd(cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
172: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE) IS
173: SELECT 'x'
174: FROM igs_en_spa_awd_aim
175: WHERE person_id = cp_person_id
176: AND course_cd = cp_course_cd
177: AND NVL(complete_ind,'N') = 'N'
178: AND end_dt IS NULL;