APPS.IGS_RE_VAL_TEX dependencies on IGS_RE_THS_EXAM_TYPE

Line 623: FROM IGS_RE_THS_EXAM_TYPE tet

619: DECLARE
620: v_dummy VARCHAR2(1);
621: CURSOR c_tet IS
622: SELECT 'x'
623: FROM IGS_RE_THS_EXAM_TYPE tet
624: WHERE tet.thesis_exam_type = p_thesis_exam_type AND
625: tet.closed_ind = 'Y';
626: BEGIN
627: -- set default value