select ...
from some_table
where organization = :par_organization
...

select t.organization
from organizations t
where t.organization_id in (select u.organization_id
                            from user_organizations u
                            where u.user_id = <user_which_runs_the_report>
                           )