7: RETURN VARCHAR2 IS
8:
9: CURSOR c_get_role IS
10: SELECT lkup.meaning role_meaning 11: FROM xle_lookups lkup, 12: xle_contact_legal_roles role
13: WHERE role.lookup_code = lkup.lookup_code
14: AND role.contact_party_id = p_contact_party_id
15: AND role.le_etb_party_id = p_le_etb_party_id