Fetch Business Roles based on IT Role

SELECT

    br.id            AS business_role_id,

    br.name          AS business_role_name,

    br.type          AS business_role_type,

    it.id            AS it_role_id,

    it.name          AS it_role_name,

    it.type          AS it_role_type

FROM identityiq.spt_bundle_requirements r

JOIN identityiq.spt_bundle it ON it.id = r.child

JOIN identityiq.spt_bundle br ON br.id = r.bundle

WHERE 

it.name = 'Pedia - IT - DPA Role';