APPS.IGS_RE_VAL_CA dependencies on IGS_EN_SPA_AWD_AIM

Line 247: FROM igs_en_spa_awd_aim

243:
244: sca.course_cd = p_sca_course_cd;
245: CURSOR c_awd_exists IS
246: SELECT 'x'
247: FROM igs_en_spa_awd_aim
248: WHERE person_id = p_person_id
249: AND course_cd = p_sca_course_cd
250: AND ( end_dt IS NULL OR
251: (end_dt IS NOT NULL AND complete_ind = 'Y')

Line 255: FROM igs_en_spa_awd_aim

251: (end_dt IS NOT NULL AND complete_ind = 'Y')
252: );
253: CURSOR c_incomp_awd IS
254: SELECT 'x'
255: FROM igs_en_spa_awd_aim
256: WHERE person_id = p_person_id
257: AND course_cd = p_sca_course_cd
258: AND NVL(complete_ind,'N') = 'N'
259: AND end_dt IS NULL;