USP_DESIGNATIONLEVELPROFILEREPORT_APPEALS

                create proc dbo.USP_DESIGNATIONLEVELPROFILEREPORT_APPEALS (@DESIGNATIONLEVELID uniqueidentifier, @CURRENCYCODE tinyint = 1)
                as
                begin
                    if @CURRENCYCODE = 1
                    begin
                        declare @CURRENCYID uniqueidentifier;
                        declare @CURRENCYISO nvarchar(3);
                        declare @CURRENCYDECIMALDIGITS tinyint;
                        declare @CURRENCYSYMBOL nvarchar(5);
                        declare @CURRENCYSYMBOLDISPLAYSETTINGCODE tinyint;

                        set @CURRENCYID = dbo.UFN_CURRENCY_GETORGANIZATIONCURRENCY();

                        select
                            @CURRENCYISO = ISO4217,
                            @CURRENCYDECIMALDIGITS = DECIMALDIGITS,
                            @CURRENCYSYMBOL = CURRENCYSYMBOL,
                            @CURRENCYSYMBOLDISPLAYSETTINGCODE = SYMBOLDISPLAYSETTINGCODE
                        from dbo.CURRENCY where ID = @CURRENCYID;

                        select distinct
                            APPEAL.[NAME],
                            APPEAL.DESCRIPTION,
                            APPEAL.STARTDATE,
                            APPEAL.ENDDATE,
                            APPEAL.ORGANIZATIONGOAL as GOAL,
                            @CURRENCYID as CURRENCYID,
                            @CURRENCYISO as CURRENCYISO,
                            @CURRENCYDECIMALDIGITS as CURRENCYDECIMALDIGITS,
                            @CURRENCYSYMBOL as CURRENCYSYMBOL,
                            @CURRENCYSYMBOLDISPLAYSETTINGCODE as CURRENCYSYMBOLDISPLAYSETTINGCODE
                        from 
                            dbo.APPEAL
                        inner join dbo.REVENUE RD on APPEAL.ID = RD.APPEALID
                        inner join dbo.REVENUESPLIT RDS on RD.ID = RDS.REVENUEID
                        inner join dbo.DESIGNATION D on RDS.DESIGNATIONID = D.ID
                        where
                            D.DESIGNATIONLEVEL1ID = @DESIGNATIONLEVELID or
                            D.DESIGNATIONLEVEL2ID = @DESIGNATIONLEVELID or
                            D.DESIGNATIONLEVEL3ID = @DESIGNATIONLEVELID or
                            D.DESIGNATIONLEVEL4ID = @DESIGNATIONLEVELID or
                            D.DESIGNATIONLEVEL5ID = @DESIGNATIONLEVELID
                        order by APPEAL.NAME;
                    end
                    else
                        select distinct
                            APPEAL.[NAME],
                            APPEAL.DESCRIPTION,
                            APPEAL.STARTDATE,
                            APPEAL.ENDDATE,
                            APPEAL.GOAL,
                            CURRENCYPROPERTIES.ID as CURRENCYID,
                            CURRENCYPROPERTIES.ISO4217 as CURRENCYISO,
                            CURRENCYPROPERTIES.DECIMALDIGITS as CURRENCYDECIMALDIGITS,
                            CURRENCYPROPERTIES.CURRENCYSYMBOL as CURRENCYSYMBOL,
                            CURRENCYPROPERTIES.SYMBOLDISPLAYSETTINGCODE as CURRENCYSYMBOLDISPLAYSETTINGCODE
                        from 
                            dbo.APPEAL
                        inner join dbo.REVENUE RD on APPEAL.ID = RD.APPEALID
                        inner join dbo.REVENUESPLIT RDS on RD.ID = RDS.REVENUEID
                        inner join dbo.DESIGNATION D on RDS.DESIGNATIONID = D.ID
                        outer apply dbo.UFN_CURRENCY_GETPROPERTIES(APPEAL.BASECURRENCYID) CURRENCYPROPERTIES
                        where
                            D.DESIGNATIONLEVEL1ID = @DESIGNATIONLEVELID or
                            D.DESIGNATIONLEVEL2ID = @DESIGNATIONLEVELID or
                            D.DESIGNATIONLEVEL3ID = @DESIGNATIONLEVELID or
                            D.DESIGNATIONLEVEL4ID = @DESIGNATIONLEVELID or
                            D.DESIGNATIONLEVEL5ID = @DESIGNATIONLEVELID
                        order by APPEAL.NAME;
                end