SQL to get roles assigned to user in Oracle Fusion

Use the below SQL to get roles assigned to user in Oracle Fusion

SELECT a.username,
       c.role_name
FROM   per_users a,
       per_user_roles b,
       per_roles_dn_vl c
WHERE  a.user_id = b.user_id
       AND b.role_id = c.role_id
       AND username = 'user.name'