UFN_CLIENTUSERS_GETIDLISTBYCURRENTCLIENTUSERID

create function dbo.UFN_CLIENTUSERS_GETIDLISTBYCURRENTCLIENTUSERID(@CLIENTUSERID int)
returns table
as 
return (
  select BOSU.ClientUsersID as CLIENTUSERID
  from dbo.BackOfficeSystemPeople BOSP 
  join dbo.BackOfficeSystemUsers BOSU on BOSP.ID = BOSU.BackofficePeopleID
  join (    
      select C.ID, C.SEQUENCEID from dbo.CONSTITUENT C 
      join dbo.BackOfficeSystemPeople BOSP on C.SEQUENCEID = BOSP.BackofficeRecordID
      join dbo.BackOfficeSystemUsers BOSU on BOSP.ID = BOSU.BackofficePeopleID 
      where BOSU.ClientUsersID = @CLIENTUSERID
  ) C on C.SEQUENCEID = BOSP.BackofficeRecordID

);