APPS.IGS_RE_SPRVSR_LGCY_PUB dependencies on IGS_PE_PERSON

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

Line 205: l_staff_member_ind igs_pe_person.staff_member_ind%TYPE;

201: WHERE org_unit_cd = cp_org_unit_cd;
202:
203: TYPE c_ref_cur IS REF CURSOR;
204:
205: l_staff_member_ind igs_pe_person.staff_member_ind%TYPE;
206: l_message_name VARCHAR2(30) DEFAULT NULL;
207: l_result BOOLEAN;
208: l_where_clause VARCHAR2(450);
209: c_org_cur c_ref_cur ;