UFN_INCENTIVELEVEL_GETBENEFITS

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