APPS.IGS_RE_GEN_001 dependencies on IGS_PS_UNIT_VER

Line 822: IGS_PS_UNIT_VER uv

818: sua.uoo_id,
819: sua.version_number
820: FROM IGS_EN_SU_ATTEMPT sua,
821: IGS_EN_STDNT_PS_ATT sca,
822: IGS_PS_UNIT_VER uv
823: WHERE sua.person_id = cp_person_id AND
824: sua.course_cd = cp_course_cd AND
825: sua.uoo_id = cp_uoo_id AND
826: sca.person_id = sua.person_id AND

Line 861: -- 2. Select detail from IGS_PS_UNIT attempt and IGS_PS_UNIT version tables

857: CLOSE c_ca;
858: RETURN NULL;
859: END IF;
860: CLOSE c_ca;
861: -- 2. Select detail from IGS_PS_UNIT attempt and IGS_PS_UNIT version tables
862: OPEN c_sua(p_person_id,p_course_cd,p_uoo_id);
863: FETCH c_sua INTO
864: v_sua_override_eftsu,
865: v_sua_cal_type,