USP_CLIENTUSER_GET_BY_CONSTITUENTID

create procedure dbo.USP_CLIENTUSER_GET_BY_CONSTITUENTID
(@CONSTITUENTID uniqueidentifier)
as
begin

    SELECT cu.ID, cu.UserName, CU.Password
    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  
    INNER JOIN dbo.CONSTITUENT C
        ON bosp.BackofficeRecordID = C.SEQUENCEID     
    WHERE C.ID = @CONSTITUENTID
end