UFN_APPEAL_GETBENEFITDETAILS_PCT_2

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

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode
@APPEALID	uniqueidentifier	IN
@GIFTAMOUNT	money	IN
@TRANSACTIONCURRENCYID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_APPEAL_GETBENEFITDETAILS_PCT_2
            (
                @APPEALID uniqueidentifier,
                @GIFTAMOUNT money,
                @TRANSACTIONCURRENCYID uniqueidentifier
            )
            returns @RESULT table
            (
                ID uniqueidentifier, 
                BENEFITID uniqueidentifier,
                VALUEPERCENT numeric(20,4),
                QUANTITY int,
                SEQUENCE int
            )
            as
            begin
                declare @APPEALBENEFITID uniqueidentifier; 
                set @APPEALBENEFITID = null;

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

                if not @APPEALBENEFITID is null
                    insert into @RESULT
                        select
                            APPEALBENEFITDETAIL.ID,
                            APPEALBENEFITDETAIL.BENEFITID,
                            APPEALBENEFITDETAIL.VALUEPERCENT,
                            APPEALBENEFITDETAIL.QUANTITY,
                            APPEALBENEFITDETAIL.SEQUENCE

                        from dbo.APPEALBENEFITDETAIL
                        inner join dbo.BENEFIT on APPEALBENEFITDETAIL.BENEFITID = BENEFIT.ID
                        where APPEALBENEFITID = @APPEALBENEFITID and BENEFIT.USEPERCENT = 1;

                return;
            end