USP_DATALIST_GETBACKOFFICESYSTEMPEOPLEID

create procedure dbo.USP_DATALIST_GETBACKOFFICESYSTEMPEOPLEID(@USERID int)
as
    set nocount on;

    Select bosp.ID as BackOfficeSystemPeopleId
  FROM dbo.ClientUsers cu    
    INNER JOIN dbo.BackOfficeSystemUsers bosu   
      ON cu.ID = bosu.ClientUsersID AND bosu.[current] = 1 AND cu.Deleted = 0    
    INNER JOIN dbo.BackOfficeSystemPeople bosp   
      ON bosp.ID = bosu.BackofficePeopleID AND bosp.BackOfficeSystemID = 0   
  WHERE cu.ID = @USERID