UFN_CONSTITUENTRECOGNITION_GETBENEFITS

        CREATE function dbo.UFN_CONSTITUENTRECOGNITION_GETBENEFITS(@CONSTITUENTRECOGNITIONID uniqueidentifier)
        returns table
        as
        return
        (
        select 
            CRB.[ID], 
            CRB.[BENEFITID], 
            CRB.[QUANTITY], 
            CRB.[UNITVALUE], 
            CRB.QUANTITY * UNITVALUE as [TOTALVALUE],
            CRB.[DETAILS], 
            CRB.[SEQUENCE] 
        from dbo.CONSTITUENTRECOGNITIONBENEFIT CRB
        inner join dbo.CONSTITUENTRECOGNITION CR on 
            CRB.CONSTITUENTRECOGNITIONID = CR.ID
        inner join (
            select RECOGNITIONPROGRAMID, CONSTITUENTID
            from dbo.CONSTITUENTRECOGNITION
            where ID = @CONSTITUENTRECOGNITIONID) T on
            T.RECOGNITIONPROGRAMID = CR.RECOGNITIONPROGRAMID and 
            T.CONSTITUENTID = CR.CONSTITUENTID
        )