2768: FROM HZ_PARTIES per,
2769: xle_entity_profiles xep,
2770: HZ_RELATIONSHIPS rel,
2771: hz_person_profiles hzpp,
2772: HZ_ORG_CONTACTS con
2773: --XLE_CONTACT_LEGAL_ROLES rol
2774: WHERE rel.relationship_code = 'CONTACT_OF'
2775: AND rel.object_id = xep.party_id
2776: AND per.party_id = hzpp.party_id
2796: FROM HZ_PARTIES per,
2797: xle_etb_profiles etb,
2798: HZ_RELATIONSHIPS rel,
2799: hz_person_profiles hzpp,
2800: HZ_ORG_CONTACTS con
2801: -- XLE_CONTACT_LEGAL_ROLES rol
2802: WHERE rel.relationship_code = 'CONTACT_OF'
2803: AND rel.object_id = etb.party_id
2804: AND per.party_id = hzpp.party_id