UFN_SELECTION_REVENUE_NOPLEDGEPAYMENTS

            CREATE function dbo.UFN_SELECTION_REVENUE_NOPLEDGEPAYMENTS()
            returns table
            as return
                select distinct
                    REVENUE.ID
                from 
                    dbo.REVENUE
                inner join 
                    dbo.REVENUESPLIT on REVENUE.ID = REVENUESPLIT.REVENUEID
                where
                    REVENUE.TRANSACTIONTYPECODE <> 2
                    and REVENUESPLIT.APPLICATIONCODE <> 2;