APPS.IGS_RE_GEN_002 dependencies on IGS_RE_SPRVSR

Line 63: FROM IGS_RE_SPRVSR rsup

59: WHERE csc.person_id = p_person_id AND
60: csc.ca_sequence_number = p_ca_sequence_number;
61: CURSOR c_rsup IS
62: SELECT 'X'
63: FROM IGS_RE_SPRVSR rsup
64: WHERE rsup.ca_person_id = p_person_id AND
65: rsup.ca_sequence_number = p_ca_sequence_number AND
66: rsup.start_dt <= p_effective_dt AND
67: NVL(rsup.end_dt, IGS_GE_DATE.IGSDATE('9999/01/01')) >= p_effective_dt;