APPS.IGS_RE_VAL_TPM dependencies on IGS_RE_SPRVSR

Line 287: FROM IGS_RE_SPRVSR rsup

283: cst_lapsed,
284: cst_intermit);
285: CURSOR c_rsup IS
286: SELECT 'x'
287: FROM IGS_RE_SPRVSR rsup
288: WHERE rsup.ca_person_id = p_ca_person_id AND
289: rsup.ca_sequence_number = p_ca_sequence_number AND
290: rsup.person_id = p_person_id AND
291: rsup.start_dt <= SYSDATE AND