USP_REVENUE_BENEFIT_DATALIST_GETDATA

            create procedure dbo.USP_REVENUE_BENEFIT_DATALIST_GETDATA(@REVENUEID uniqueidentifier)
            as 
                set nocount on;

                select
                    [RDB].ID,
                    BENEFIT.NAME,
                    QUANTITY,
                    UNITVALUE,
                    TOTALVALUE,
                    DETAILS,
                    SEQUENCE
                from dbo.UFN_REVENUE_GETBENEFITS(@REVENUEID) as [RDB]
                inner join dbo.BENEFIT on BENEFIT.ID = [RDB].BENEFITID