APPS.IGS_EN_GEN_002 dependencies on IGS_RE_CANDIDATURE

Line 756: FROM IGS_RE_CANDIDATURE ca

752: scho.end_dt > p_effective_dt);
753: CURSOR c_ca
754: IS
755: SELECT 'x'
756: FROM IGS_RE_CANDIDATURE ca
757: WHERE ca.person_id = p_person_id AND
758: ca.sca_course_cd = p_course_cd;
759: CURSOR c_scae
760: IS

Line 812: -- Check for the existence of a research IGS_RE_CANDIDATURE record

808: CLOSE c_scho;
809: END IF;
810: END IF;
811: IF p_check_research = TRUE THEN
812: -- Check for the existence of a research IGS_RE_CANDIDATURE record
813: OPEN c_ca;
814: FETCH c_ca INTO v_check;
815: IF c_ca%FOUND THEN
816: CLOSE c_ca;