USP_DATALIST_DESIGNATIONLEVELGIFTFEES

                CREATE procedure dbo.USP_DATALIST_DESIGNATIONLEVELGIFTFEES(@ID uniqueidentifier)
                as begin
                set nocount on;

                if dbo.UFN_DESIGNATIONLEVELGIFTFEE_OVERRIDESTRUCTURE(@ID) = 0
                    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
                else
                    select
                        DLGFS.ID,
                        DLGFS.FROMAMOUNT,
                        dbo.UFN_CURRENCY_ROUND((select top (1) (SUB.FROMAMOUNT - (1.0/(POWER(10.0,convert(float,C.DECIMALDIGITS))))) from dbo.DESIGNATIONLEVELGIFTFEESTRUCTURE SUB
                                    where DESIGNATIONLEVELID = @ID and
                                        SUB.FROMAMOUNT > DLGFS.FROMAMOUNT
                                    order by SUB.FROMAMOUNT asc), C.DECIMALDIGITS, C.ROUNDINGTYPECODE) MAXAMOUNT,
                        DLGFS.FEE,
                        DLGFS.BASECURRENCYID
                    from 
                        dbo.DESIGNATIONLEVELGIFTFEESTRUCTURE DLGFS
                    join
                        dbo.CURRENCY C on C.ID = DLGFS.BASECURRENCYID
                    where DESIGNATIONLEVELID = @ID
                    order by FROMAMOUNT


                end