175: SELECT Parties.PARTY_NAME ASSIGNEE_NAME
176: , AssigneeTypeLookup.MEANING ASSIGNEE_TYPE
177: , Company.PARTY_NAME ASSIGNEE_COMPANY
178: FROM FND_LOOKUPS AssigneeTypeLookup
179: , HZ_RELATIONSHIPS Emp_Cmpy
180: , HZ_PARTIES Company
181: , HZ_PARTIES Parties
182: WHERE AssigneeTypeLookup.LOOKUP_CODE = 'PERSON'
183: AND AssigneeTypeLookup.LOOKUP_TYPE = 'ENG_ROUTE_ASSIGNEE_TYPES'