SQL for getting Person's User Role details in Oracle HCM Cloud environment

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

SELECT 
               P.PERSON_NUMBER
              ,U.USERNAME
              ,U.SUSPENDED
              ,RD.ROLE_COMMON_NAME
              ,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

AND         UR.ACTIVE_FLAG    =    ‘Y’
ORDER BY U.USERNAME