What query can I use to get the ResourcePartyNumber and ResourceOrganizationName?

In Oracle Transactional Business Intelligence (OTBI) try the following query:

SELECT hzp.party_number ResourcePartyNumber,
(SELECT name FROM fusion.hr_organization_units_f_tl WHERE organization_id = gm.group_id and language = 'US' and rownum = 1) ResourceOrganizationName
FROM fusion.jtf_rs_group_members gm,
fusion.jtf_rs_role_relations rr,
fusion.jtf_rs_roles_b rs,
fusion.hz_parties hzp
WHERE gm.delete_flag = 'N'
AND gm.group_member_id = rr.role_resource_id
AND rr.delete_flag = 'N'
AND rr.role_id = rs.role_id
--AND rs.manager_flag = 'Y'
AND TRUNC(sysdate) BETWEEN rr.start_date_active AND rr.end_date_active
AND gm.resource_id = hzp.party_id
--and hzp.party_number = 'XXXXX'