APPS.IGS_HE_IMPORT_DATA dependencies on HZ_PERSON_PROFILES

Line 29: FROM hz_parties p , hz_person_profiles pp

25: SELECT p.party_id person_id, p.person_last_name surname,
26: p.person_first_name given_names,
27: pp.gender sex,
28: pp.date_of_birth birth_dt
29: FROM hz_parties p , hz_person_profiles pp
30: WHERE p.party_number = cp_person_number AND
31: pp.party_id(+)=p.party_id AND
32: SYSDATE BETWEEN NVL(pp.effective_start_date,SYSDATE) AND NVL(pp.effective_end_date,SYSDATE);
33: c_pe_det_rec c_pe_det%ROWTYPE ;