Costing Organization LOV — Security-Filtered Report Parameter

Lists the Costing Organizations the current user has data access to — used as the LOV source for a "Costing Organization" report parameter.

/* Costing Organizations list that an user has access */
select
    co.cost_org_name
  , co.cost_org_id
from
    CST_COST_ORGS_V co
where
    1             =1
    and co.status = 'A'
    and co.cost_org_id in
    (
        select distinct
            furda.CST_ORGANIZATION_ID
        from
            per_users                   pu
          , FUN_USER_ROLE_DATA_ASGNMNTS furda
        where
            1                              =1
            and pu.USER_GUID               = furda.USER_GUID
            and nvl(furda.active_flag,'N') = 'Y'
            and sysdate between furda.start_date_active and nvl(furda.end_date_active,sysdate)
            and upper(pu.username) = upper(:xdo_user_name)
            -- and upper(pu.username) = upper('<login userid>')
    )
order by
    1