USP_REPORT_APPEALPROFILE_BASEINFORMATION

            CREATE procedure dbo.USP_REPORT_APPEALPROFILE_BASEINFORMATION
            (
                @APPEALID uniqueidentifier = null,
                @SHOW bit = null,
                @CURRENCYCODE tinyint = null
            )
            as
                set nocount on;

                declare @ORGANIZATIONCURRENCYID uniqueidentifier;

                if coalesce(@CURRENCYCODE, 1) = 1
                begin
                    set @CURRENCYCODE = 1;
                    set @ORGANIZATIONCURRENCYID = dbo.UFN_CURRENCY_GETORGANIZATIONCURRENCY();
                end
                else begin
                    set @CURRENCYCODE = 0;
                end

                begin try
                    if @SHOW = 1
                    begin
                        -- NOTE: Be sure to update AppealProfileReportSectionsHaveData.View.xml if you modify

                        -- the joins/constraints of the below query.


                        select 
                            APPEAL.[NAME],
                            APPEAL.DESCRIPTION,
                            APPEAL.STARTDATE,
                            APPEAL.ENDDATE,
                            APPEALCATEGORYCODE.DESCRIPTION as CATEGORY,
                            dbo.UDA_BUILDLIST(BUSINESSUNITCODE.DESCRIPTION) as BUSINESSUNIT,
                            SITE.NAME as SITE,
                            case @CURRENCYCODE
                                when 0 then APPEAL.GOAL
                                else APPEAL.ORGANIZATIONGOAL
                            end [GOAL],
                            APPEAL.ISACTIVE,
                            CURRENCYPROPERTIES.ID as CURRENCYID,
                            CURRENCYPROPERTIES.ISO4217 as CURRENCYISO,
                            CURRENCYPROPERTIES.DECIMALDIGITS as CURRENCYDECIMALDIGITS,
                            CURRENCYPROPERTIES.CURRENCYSYMBOL as CURRENCYSYMBOL,
                            CURRENCYPROPERTIES.SYMBOLDISPLAYSETTINGCODE as CURRENCYSYMBOLDISPLAYSETTINGCODE,
                            dbo.UFN_CURRENCY_GETDESCRIPTION(APPEAL.BASECURRENCYID)as BASECURRENCYNAME
                        from dbo.APPEAL
                            left join dbo.APPEALCATEGORYCODE on APPEAL.APPEALCATEGORYCODEID = APPEALCATEGORYCODE.ID
              left join dbo.APPEALBUSINESSUNIT on APPEALBUSINESSUNIT.APPEALID = APPEAL.ID
              left join dbo.BUSINESSUNITCODE on APPEALBUSINESSUNIT.BUSINESSUNITCODEID = BUSINESSUNITCODE.ID
                            left join dbo.SITE on APPEAL.SITEID=SITE.ID
                            outer apply dbo.UFN_CURRENCY_GETPROPERTIES(coalesce(@ORGANIZATIONCURRENCYID, APPEAL.BASECURRENCYID)) CURRENCYPROPERTIES
                        where (APPEAL.ID = @APPEALID)
            group by APPEAL.NAME,
            APPEAL.DESCRIPTION,
            APPEAL.STARTDATE,
            APPEAL.ENDDATE,
            APPEALCATEGORYCODE.DESCRIPTION,
            SITE.NAME,
            APPEAL.GOAL,
                APPEAL.ORGANIZATIONGOAL,
                APPEAL.ISACTIVE,
                CURRENCYPROPERTIES.ID,
                CURRENCYPROPERTIES.ISO4217,
                CURRENCYPROPERTIES.DECIMALDIGITS,
                CURRENCYPROPERTIES.CURRENCYSYMBOL,
                CURRENCYPROPERTIES.SYMBOLDISPLAYSETTINGCODE,
                APPEAL.BASECURRENCYID;
                    end
                    else
                    begin
                        select
                            APPEAL.[NAME],
                            APPEAL.DESCRIPTION,
                            APPEAL.STARTDATE,
                            APPEAL.ENDDATE,
                            null as CATEGORY,
                            null as BUSINESSUNIT,
                            null as SITE,
                            case @CURRENCYCODE
                                when 0 then APPEAL.GOAL
                                else APPEAL.ORGANIZATIONGOAL
                            end [GOAL],
                            APPEAL.ISACTIVE as ISACTIVE,
                            CURRENCYPROPERTIES.ID as CURRENCYID,
                            CURRENCYPROPERTIES.ISO4217 as CURRENCYISO,
                            CURRENCYPROPERTIES.DECIMALDIGITS as CURRENCYDECIMALDIGITS,
                            CURRENCYPROPERTIES.CURRENCYSYMBOL as CURRENCYSYMBOL,
                            CURRENCYPROPERTIES.SYMBOLDISPLAYSETTINGCODE as CURRENCYSYMBOLDISPLAYSETTINGCODE,
                            dbo.UFN_CURRENCY_GETDESCRIPTION(APPEAL.BASECURRENCYID)as BASECURRENCYNAME
                        from
                            dbo.APPEAL
                            outer apply dbo.UFN_CURRENCY_GETPROPERTIES(coalesce(@ORGANIZATIONCURRENCYID, APPEAL.BASECURRENCYID)) CURRENCYPROPERTIES
                        where
                            APPEAL.ID = @APPEALID;
                    end
                end try

                begin catch
                    exec dbo.USP_RAISE_ERROR;
                    return 1;
                end catch

                return 0;