APPS.IGS_RE_VAL_TEX dependencies on IGS_RE_SPRVSR

Line 162: FROM IGS_RE_SPRVSR rsup,

158: tex.thesis_result_cd IS NULL;
159: v_tex_exists VARCHAR2(1);
160: CURSOR c_rsup IS
161: SELECT 'x'
162: FROM IGS_RE_SPRVSR rsup,
163: IGS_RE_SPRVSR_TYPE rst
164: WHERE rsup.ca_person_id = p_person_id AND
165: rsup.ca_sequence_number = p_ca_sequence_number AND
166: rsup.start_dt <= SYSDATE AND

Line 163: IGS_RE_SPRVSR_TYPE rst

159: v_tex_exists VARCHAR2(1);
160: CURSOR c_rsup IS
161: SELECT 'x'
162: FROM IGS_RE_SPRVSR rsup,
163: IGS_RE_SPRVSR_TYPE rst
164: WHERE rsup.ca_person_id = p_person_id AND
165: rsup.ca_sequence_number = p_ca_sequence_number AND
166: rsup.start_dt <= SYSDATE AND
167: (rsup.end_dt IS NULL OR