Active users in a specific company

I’ve actually managed to sort this one out by using user_group in a query rather than a company. ( This solution was used previously on the forum - my bad)

select fu.identity
        , fu.web_user Directory_ID
        , fu.active
        , user_group_api.Get_Name(fug.user_group_id) User_Group_Name
from fnd_user fu
     LEFT JOIN Fnd_User_By_Group fug
     ON fu.identity = fug.identity
where fu.active = ' TRUE' AND user_group_api.Get_Name(fug.user_group_id) = 'NAME OF THE GROUP'