APPS.IGS_FI_AD_HOC_WAV dependencies on HZ_PERSON_PROFILES

Line 264: FROM hz_parties hz, hz_person_profiles pp

260:
261: CURSOR c_per_id (cp_n_person_id hz_parties.party_id%TYPE) IS
262: SELECT hz.party_number person_number,
263: nvl(pp.person_name, hz.party_name) full_name
264: FROM hz_parties hz, hz_person_profiles pp
265: WHERE hz.party_id = cp_n_person_id
266: AND pp.party_id = cp_n_person_id;
267:
268: l_v_per_id c_per_id%ROWTYPE;