UFN_MEMBERSHIPBENEFIT_GETNAME

            CREATE function dbo.UFN_MEMBERSHIPBENEFIT_GETNAME
      (
        @MEMBERSHIPID uniqueidentifier
      )
      returns nvarchar(100) with execute as caller
      as
      begin 
      declare @NAME nvarchar(100)
      (
        select @NAME=BENEFIT.NAME
        from dbo.REVENUEBENEFIT 
        inner join dbo.BENEFIT on REVENUEBENEFIT.BENEFITID=BENEFIT.ID
        inner join dbo.FINANCIALTRANSACTION on REVENUEBENEFIT.REVENUEID = FINANCIALTRANSACTION.ID
        inner join dbo.FINANCIALTRANSACTIONLINEITEM on FINANCIALTRANSACTION.ID = FINANCIALTRANSACTIONLINEITEM.FINANCIALTRANSACTIONID
        inner join dbo.MEMBERSHIPTRANSACTION on FINANCIALTRANSACTIONLINEITEM.ID = MEMBERSHIPTRANSACTION.REVENUESPLITID
        where MEMBERSHIPTRANSACTION.MEMBERSHIPID = @MEMBERSHIPID
        and FINANCIALTRANSACTIONLINEITEM.TYPECODE <> 1
        and FINANCIALTRANSACTION.DELETEDON is null 
        and FINANCIALTRANSACTIONLINEITEM.DELETEDON is null
       )
       return @NAME
       end