APPS.HZ_PARTY_ACQUIRE dependencies on HZ_PERSON_PROFILES

Line 234: FROM HZ_PARTIES p, HZ_PERSON_PROFILES pe

230: ,p.KNOWN_AS2
231: ,p.KNOWN_AS3
232: ,p.KNOWN_AS4
233: ,p.KNOWN_AS5
234: FROM HZ_PARTIES p, HZ_PERSON_PROFILES pe
235: WHERE p.party_id = p_party_id
236: AND pe.effective_end_date is NULL
237: AND p.party_id = pe.party_id;
238: CURSOR custom_attribs IS

Line 883: FROM HZ_ORG_CONTACTS o, HZ_RELATIONSHIPS pr, HZ_PERSON_PROFILES ps

879: ,ps.PERSON_TITLE
880: ,ps.PLACE_OF_BIRTH
881: ,ps.TAX_NAME
882: ,ps.TAX_REFERENCE
883: FROM HZ_ORG_CONTACTS o, HZ_RELATIONSHIPS pr, HZ_PERSON_PROFILES ps
884: WHERE o.party_relationship_id = pr.relationship_id
885: AND pr.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
886: AND pr.OBJECT_TABLE_NAME = 'HZ_PARTIES'
887: AND pr.DIRECTIONAL_FLAG = 'F'