UFN_APPEAL_GETBENEFITDETAILS_ALL

Returns the benefit details associated with an appeal.
Return

Return Type
table
Parameters

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

Copy


            CREATE function dbo.UFN_APPEAL_GETBENEFITDETAILS_ALL
            (
                @APPEALID uniqueidentifier,
                @GIFTAMOUNT money
            )
            returns @RESULT table
            (
                ID uniqueidentifier, 
                BENEFITID uniqueidentifier,
                VALUE money,
                QUANTITY int,
                SEQUENCE int,
                VALUEPERCENT int,
                USEPERCENT bit,
        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,
                            APPEALBENEFITDETAIL.VALUEPERCENT,
                            BENEFIT.USEPERCENT,
              APPEALBENEFITDETAIL.BASECURRENCYID
                        from dbo.APPEALBENEFITDETAIL
                        inner join dbo.BENEFIT 
                            on APPEALBENEFITDETAIL.BENEFITID = BENEFIT.ID
                        where APPEALBENEFITID = @APPEALBENEFITID;

                return;
            end