UFN_APPEAL_GETBENEFITDETAILS

Returns the benefit details associated with an appeal and a appeal benefit level dollar amount.
Return

Return Type
table
Parameters

Parameter	Parameter Type	Mode	Description
@APPEALID	uniqueidentifier	IN
@GIFTAMOUNT	money	IN
Definition

Copy


            CREATE function dbo.UFN_APPEAL_GETBENEFITDETAILS
            (
                @APPEALID uniqueidentifier,
                @GIFTAMOUNT money
            )
            returns @RESULT table
            (
                ID uniqueidentifier, 
                BENEFITID uniqueidentifier,
                VALUE money,
                QUANTITY int,
                SEQUENCE int,
                BASECURRENCYID uniqueidentifier
            )
            as
            begin
                declare @APPEALBENEFITID uniqueidentifier; 
                set @APPEALBENEFITID = null;

                select top 1
                    @APPEALBENEFITID = ID 
                from dbo.APPEALBENEFIT 
                where APPEALID = @APPEALID 
                    and AMOUNT <= @GIFTAMOUNT 
                order by AMOUNT desc;

                if not @APPEALBENEFITID is null
                    insert into @RESULT
                        select
                            APPEALBENEFITDETAIL.ID,
                            APPEALBENEFITDETAIL.BENEFITID,
                            APPEALBENEFITDETAIL.VALUE,
                            APPEALBENEFITDETAIL.QUANTITY,
                            APPEALBENEFITDETAIL.SEQUENCE,
                            BENEFIT.BASECURRENCYID
                        from dbo.APPEALBENEFITDETAIL
                            inner join dbo.BENEFIT 
                                on APPEALBENEFITDETAIL.BENEFITID = BENEFIT.ID
                        where APPEALBENEFITID = @APPEALBENEFITID and BENEFIT.USEPERCENT = 0;

                return;
            end