BIP Query Job Roles and the roles assigned to them

Summary:

I'm trying to create a BIP query that shows me Job Roles and the roles assigned to them.

I tried to create the report, but I can only get it to this point:

select prd.role_id,
prdt.ROLE_NAME,
prdt.DESCRIPTION,
prd.ROLE_COMMON_NAME,
prd.ROLE_GUID
from per_roles_dn_tl prdt,
PER_ROLES_DN prd
where prd.JOB_ROLE = 'Y'
and prd.ACTIVE_FLAG='Y'
and prd.role_id = prdt.role_id

This gives me all the Job Roles, but I can't determine the relationship between the job role and the roles assigned to it.