Query to Find Privillages under Role and its Inherited Roles

Summary:

Need query to get privileges assigned under Role and its inherited Roles.

Content (please ensure you mask any confidential information):

Tried Below query but looks like its not giving inherited Role Privileges.

SELECT C.role_name,B.name,B.code
FROM
ASE_PRIV_ROLE_MBR A,
ASE_PRIVILEGE_VL B,
ASE_ROLE_VL C
WHERE 1=1
AND A.PRIVILEGE_ID = B.PRIVILEGE_ID
AND A.Role_id=c.Role_id
AND (C.EFFECTIVE_END_DATE >= sysdate OR C.EFFECTIVE_END_DATE IS NULL)
AND C.role_name='Employee_Copy'

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):