APPS.IGS_RE_VAL_TEX dependencies on IGS_RE_SPRVSR_TYPE

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