USP_REPORT_PAPERLESSMANDATESINSTRUCTIONPROCESS_CONTROL

            CREATE procedure dbo.USP_REPORT_PAPERLESSMANDATESINSTRUCTIONPROCESS_CONTROL
            (
                @ID nvarchar(36)
            )
            with execute as owner
            as
            set nocount on;

            declare @TABLENAME nvarchar(255);
            declare @SQL nvarchar(4000);

            begin try
                select 
                    @TABLENAME = BUSINESSPROCESSOUTPUT.TABLENAME
                from 
                    dbo.BUSINESSPROCESSSTATUS
                    inner join dbo.BUSINESSPROCESSOUTPUT on BUSINESSPROCESSSTATUS.ID = BUSINESSPROCESSOUTPUT.BUSINESSPROCESSSTATUSID
                    where BUSINESSPROCESSSTATUS.ID = @ID and BUSINESSPROCESSOUTPUT.TABLEKEY = 'CONTROL';

                if not @TABLENAME is null and not OBJECT_ID(@TABLENAME) is null
                    set @SQL = 'exec dbo.USP_GET_KEY_ACCESS; 
                                select
                                    [OUTPUT].CONSTITUENTNAME,
                                    [OUTPUT].TRANSACTIONTYPE,
                                    [OUTPUT].GIFTDATE,
                                    [OUTPUT].AMOUNT,
                                    [OUTPUT].INSTRUCTION,
                                    coalesce(substring(convert(nvarchar(50), DecryptByKey(CONSTITUENTACCOUNT.ACCOUNTNUMBER)),1,8),'''') as ACCOUNTNUMBER,
                                    [OUTPUT].TRANSACTIONCODE as SORTCODE,
                                    FINANCIALINSTITUTION.DESCRIPTION as BANK,
                                    CONSTITUENT.LOOKUPID,
                                    CURRENCYPROPERTIES.ISO4217 as ISOCURRENCYCODE,
                                    CURRENCYPROPERTIES.CURRENCYSYMBOL,
                                    CURRENCYPROPERTIES.SYMBOLDISPLAYSETTINGCODE CURRENCYSYMBOLDISPLAYSETTINGCODE,
                                    CURRENCYPROPERTIES.DECIMALDIGITS
                                from
                                    ' + @TABLENAME + ' [OUTPUT]
                                    inner join dbo.CONSTITUENTACCOUNT on [OUTPUT].ACCOUNTID = CONSTITUENTACCOUNT.ID 
                                    inner join dbo.FINANCIALINSTITUTION on CONSTITUENTACCOUNT.FINANCIALINSTITUTIONID = FINANCIALINSTITUTION.ID 
                                    inner join dbo.CONSTITUENT on CONSTITUENTACCOUNT.CONSTITUENTID = CONSTITUENT.ID
                                    inner join dbo.FINANCIALTRANSACTION on [OUTPUT].REVENUEID = FINANCIALTRANSACTION.ID
                                    outer apply dbo.UFN_CURRENCY_GETPROPERTIES(FINANCIALTRANSACTION.TRANSACTIONCURRENCYID) CURRENCYPROPERTIES
                                where FINANCIALTRANSACTION.DELETEDON is null
                                close symmetric key sym_BBInfinity ';
                else
                    set @SQL = '
                        select
                            ID as [REASON]
                        from BUSINESSPROCESSSTATUS 
                        where 1 = 0';

                exec sp_executesql @SQL;

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

            return 0;