To get the Security Profiles and Operating Unit assigned to them - MOAC

SELECT PSP.SECURITY_PROFILE_NAME,

       PSP.SECURITY_PROFILE_ID,

       HOU.NAME,

       HOU.ORGANIZATION_ID

  FROM PER_SECURITY_PROFILES      PSP,

       PER_SECURITY_ORGANIZATIONS PSO,

       HR_OPERATING_UNITS         HOU

 WHERE PSO.SECURITY_PROFILE_ID = PSP.SECURITY_PROFILE_ID

   AND PSO.ORGANIZATION_ID = HOU.ORGANIZATION_ID;