USP_DATALIST_GIFTFEES

                CREATE procedure dbo.USP_DATALIST_GIFTFEES
                as begin
                set nocount on;

                select
                    GFS.ID,
                    GFS.FROMAMOUNT,
                    dbo.UFN_CURRENCY_ROUND((select top (1) (SUB.FROMAMOUNT - (1.0/POWER(10.0,convert(float,C.DECIMALDIGITS)))) from dbo.GIFTFEESTRUCTURE SUB
                                where SUB.FROMAMOUNT > GFS.FROMAMOUNT
                                order by SUB.FROMAMOUNT asc), C.DECIMALDIGITS, C.ROUNDINGTYPECODE) MAXAMOUNT,

                    GFS.FEE,
                    GFS.BASECURRENCYID
                from 
                    dbo.GIFTFEESTRUCTURE GFS
                join
                    dbo.CURRENCY C on C.ID = GFS.BASECURRENCYID
                order by GFS.FROMAMOUNT;

                end