UFN_SPONSORSHIP_GETBENEFITS

create function dbo.UFN_SPONSORSHIP_GETBENEFITS(@SPONSORSHIPTYPEID 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.EVENTSPONSORSHIPTYPEBENEFIT 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.EVENTSPONSORSHIPTYPEID = @SPONSORSHIPTYPEID
)