UFN_REVENUE_GETBENEFITS2

            CREATE function dbo.UFN_REVENUE_GETBENEFITS2(@REVENUEID uniqueidentifier)
            returns table
            as
            return
            (
                select 
                    [LI].[ID], 
                    RBEX.[BENEFITID], 
                    isnull(cast(LI.QUANTITY as Int), 0) as [QUANTITY], 
                    [LI].[UNITVALUE], 
                    [LI].BASEAMOUNT as [TOTALVALUE],
                    isnull(Left(LI.DESCRIPTION,255),'') as [DETAILS], 
                    LI.[SEQUENCE],
                    RBEX.PERCENTAPPLICABLEAMOUNT,
                    RBEX.VALUEPERCENT,
                    B.USEPERCENT
                from dbo.FINANCIALTRANSACTIONLINEITEM as [LI]
                inner join dbo.REVENUEBENEFIT_EXT RBEX on RBEX.ID = LI.ID
                inner join dbo.BENEFIT B on RBEX.BENEFITID = B.ID
                where 
                    LI.FINANCIALTRANSACTIONID = @REVENUEID and
                    LI.DELETEDON is null
            )