UFN_APPEALBENEFIT_GETBENEFITDETAILS2

Returns all benefit details for a given appeal benefit level.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@APPEALBENEFITID	uniqueidentifier	IN

Definition

Copy



            CREATE function dbo.UFN_APPEALBENEFIT_GETBENEFITDETAILS2(@APPEALBENEFITID uniqueidentifier)
            returns table
            as
            return
            (
                select 
                    APPEALBENEFITDETAIL.ID, 
                    APPEALBENEFITDETAIL.BENEFITID, 
                    APPEALBENEFITDETAIL.QUANTITY, 
                    APPEALBENEFITDETAIL.VALUE, 
                    APPEALBENEFITDETAIL.VALUEPERCENT, 
                    APPEALBENEFITDETAIL.SEQUENCE, 
                    BENEFIT.USEPERCENT 
                from dbo.APPEALBENEFITDETAIL 
                left join dbo.BENEFIT
                    on APPEALBENEFITDETAIL.BENEFITID = BENEFIT.ID
                where APPEALBENEFITDETAIL.APPEALBENEFITID = @APPEALBENEFITID
            )