APPS.IGS_RE_SPRVSR_LGCY_PUB dependencies on IGS_PE_PERSON_BASE_V

Line 190: FROM igs_re_sprvsr rsup, igs_pe_person_base_v pdv

186: WHERE replaced_person_id = l_repl_person_id;
187:
188: CURSOR c_date_ovrlp (l_sequence_number IN NUMBER ) IS
189: SELECT 'x'
190: FROM igs_re_sprvsr rsup, igs_pe_person_base_v pdv
191: WHERE rsup.ca_person_id = p_ca_person_id
192: AND rsup.ca_sequence_number = p_ca_sequence_number
193: AND rsup.person_id = p_person_id
194: AND rsup.sequence_number = l_sequence_number