APPS.IRC_PARTY_PERSON_UTL dependencies on HZ_PERSON_PROFILES

Line 105: from hz_person_profiles hzpp

101: ,hzpp.known_as
102: ,hzpp.person_first_name_phonetic
103: ,hzpp.person_last_name_phonetic
104: ,hzp.creation_date
105: from hz_person_profiles hzpp
106: , hz_parties hzp
107: where hzpp.party_id=p_party_id
108: and hzp.party_id=hzpp.party_id
109: and sysdate between hzpp.effective_start_date and nvl(hzpp.effective_end_date,sysdate);