APPS.IGS_FI_WAV_DTLS_WF dependencies on IGS_PE_PERSON_BASE_V

Line 51: FROM IGS_PE_PERSON_BASE_V

47: AND sequence_number = c_n_load_ci_seq_number;
48:
49: CURSOR cur_person_details(c_n_person_id IN hz_parties.party_id%TYPE) IS
50: SELECT person_number, full_name
51: FROM IGS_PE_PERSON_BASE_V
52: WHERE person_id = c_n_person_id;
53:
54: CURSOR cur_alt_person_id (c_n_person_id IN hz_parties.party_id%TYPE) IS
55: SELECT api_person_id, person_id_type

Line 183: FROM IGS_PE_PERSON_BASE_V

179: p_n_fee_ci_seq_number IN igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE) AS
180:
181: CURSOR cur_person_details(c_n_person_id IN hz_parties.party_id%TYPE) IS
182: SELECT person_number, full_name
183: FROM IGS_PE_PERSON_BASE_V
184: WHERE person_id = c_n_person_id;
185:
186: CURSOR c_seq_num IS
187: SELECT igs_fi_wav_wf_stud_s.NEXTVAL