2305: rel.object_id),
2306: hzpp.person_pre_name_adjunct -- title
2307: FROM HZ_PARTIES per,
2308: xle_entity_profiles xep,
2309: HZ_RELATIONSHIPS rel,
2310: hz_person_profiles hzpp,
2311: HZ_ORG_CONTACTS con
2312: --XLE_CONTACT_LEGAL_ROLES rol
2313: WHERE rel.relationship_code = 'CONTACT_OF'
2333: rel.object_id),
2334: hzpp.person_pre_name_adjunct --title,
2335: FROM HZ_PARTIES per,
2336: xle_etb_profiles etb,
2337: HZ_RELATIONSHIPS rel,
2338: hz_person_profiles hzpp,
2339: HZ_ORG_CONTACTS con
2340: -- XLE_CONTACT_LEGAL_ROLES rol
2341: WHERE rel.relationship_code = 'CONTACT_OF'