UFN_GETPROCESSEDDISBURSEMENTIDS

        CREATE function dbo.UFN_GETPROCESSEDDISBURSEMENTIDS()
        returns @DISBURSEMENTIDS table
        (
            DISBURSEMENTID uniqueidentifier,
            VENDORID nvarchar(4000)
        )
        with execute as caller
        as begin

            insert into @DISBURSEMENTIDS
                select
                    DISBURSEMENTID,
                    VENDORID
                from dbo.PROCESSORTRANSACTIONSETTLEMENTIMPORT

            return;

        end