USP_REPORT_GENERATETRANSACTIONS_EXCEPTION_HEADER

            CREATE procedure dbo.USP_REPORT_GENERATETRANSACTIONS_EXCEPTION_HEADER
            (
                @ID uniqueidentifier
            )
            as
            begin
                select 
                    case BUSINESSPROCESSCATALOGID
                        when 'F1606B58-8D50-4614-8752-57E1CF85DAE4' then 0 -- Generate Payments Process

                        when '8c1e67b1-fb82-4c44-ab03-417d7e70ce94' then 1 -- Credit Card Processing Process

            when 'B7974F4F-60D8-4DF5-AD5B-7B1839ABE16A' then 2 -- Direct Debit Process

            when '5FCC159B-D9F7-46AE-8980-FB5D74515C15' then 3 --Direct Debit Process UK

                        else null
                    end as BUSINESSPROCESSTYPECODE
                from dbo.BUSINESSPROCESSSTATUS
                where ID = @ID

                return 0;
            end