BI Publisher – Get all resources from a The same Business Unit as a specific Resource User

SELECT DISTINCT JTF_RS_RESOURCE_PROFILES.PARTY_ID FROM ( Select PersonNameDPEO.PERSON_NAME_ID, PersonNameDPEO.PERSON_ID, PersonNameDPEO.DISPLAY_NAME as PERSON_DISPLAY_NAME, PersonDPEO.PERSON_NUMBER, PersonDPEO.PERSON_ID as PERSON_ID2, PersonDPEO.EFFECTIVE_START_DATE as PERSON_ESDATE, PersonDPEO.EFFECTIVE_END_DATE as PERSON_EEDATE, JobDPEO.JOB_ID, JobDPEO.NAME as JOB_NAME, BusinessUnitPEO.BU_ID, BusinessUnitPEO.BU_NAME, AssignmentSupervisorDPEO.ASSIGNMENT_ID, AssignmentSupervisorDPEO.ASSIGNMENT_SUPERVISOR_ID, AssignmentSupervisorDPEO.MANAGER_ID,…