UFN_CREDITCARDPROCESSING_GETRESUMEINFO

            CREATE function dbo.UFN_CREDITCARDPROCESSING_GETRESUMEINFO
            (
                @BATCHID uniqueidentifier
            )
            returns table
            as return
            (
                with BPS(IDENTIFIER) as 
                (
                    select 
                        cast(BUSINESSPROCESSSTATUS.ID as nvarchar(36)) as [IDENTIFIER] 
                    from dbo.BUSINESSPROCESSSTATUS 
                    where BUSINESSPROCESSCATALOGID = '8c1e67b1-fb82-4c44-ab03-417d7e70ce94' 
                        and STATUSCODE <> 1
                )
                select
                    MAPPINGTABLE,                
                    BBPSBATCHPROCESSID,
                    RECORDSSUBMITTED,
                    ID
                from dbo.CREDITCARDPROCESSINGSTATE 
                where CREDITCARDPROCESSINGSTATE.BUSINESSPROCESSSTATUSIDENTIFIER not in (select ID from BPS) 
                    and CREDITCARDPROCESSINGSTATE.BATCHID = @BATCHID                
            )