SELECT Person.PERSON_ID, Role.*
FROM V_UPDATABLE_PERSON Person, GU_PERSON GuPerson, V_UPDATABLE_VO_PERSON_CATEGORY VoPersonCategory, PERSON_ROLE PersonRole, VO_ROLE VoRole, ROLE Role
WHERE GuPerson.PERSON_ID = Person.PERSON_ID
AND Person.VO_PERSON_CATEGORY_ID = VoPersonCategory.VO_PERSON_CATEGORY_ID
AND GuPerson.GUI_USER_ID = ?
AND person.person_status_id = 0
AND Person.PERSON_ID = PersonRole.PERSON_ID
AND PersonRole.VO_ROLE_ID = VoRole.VO_ROLE_ID
AND VoRole.ROLE_ID = Role.ROLE_ID
AND Role.VALIDATION_STATUS_ID >= 81
ORDER BY Person.LAST_NAME,Person.FIRST_NAME;