UFN_REGISTRATION_GETBENEFITS

create function dbo.UFN_REGISTRATION_GETBENEFITS(@EVENTPRICEID uniqueidentifier)
returns table
as
return
(
  SELECT 
    eb.[ID], 
    eb.[BENEFITID], 
    eb.[QUANTITY],
    b.NAME,
    b.[DESCRIPTION] AS DETAILS,
    b.VALUE AS UNITVALUE,
    bext.DEDUCTIBLEAMOUNT AS DEDUCTIBLEUNITVALUE,
    eb.QUANTITY * b.VALUE AS [TOTALVALUE],
    eb.QUANTITY * bext.DEDUCTIBLEAMOUNT AS DEDUCTIBLEVALUE
  FROM dbo.EventpriceBenefit eb (NOLOCK)
  INNER JOIN dbo.BENEFIT b (NOLOCK) ON eb.BENEFITID = b.ID
  LEFT OUTER JOIN dbo.BENEFITEXTENSION bext (NOLOCK) ON bext.BENEFITID = b.ID
  WHERE eb.EVENTPRICEID = @EVENTPRICEID
)