SQL for getting all the Role names present in Oracle HCM Cloud environment and also assigned to Users

Sample SQL Query (You can modify as required):
-----------------------------------

SELECT 
               DISTINCT RDT.ROLE_NAME
FROM PER_USERS U, PER_ALL_PEOPLE_F P
 ,PER_USER_ROLES UR, PER_ROLES_DN RD, PER_ROLES_DN_TL RDT
WHERE   U.PERSON_ID          =    P.PERSON_ID
AND         U.USER_ID               =    UR.USER_ID
AND         UR.ROLE_ID             =    RD.ROLE_ID
AND         UR.ROLE_ID             =    RDT.ROLE_ID