UFN_SELECTION_REVENUE_LEGACYHELDRECURRINGGIFTS

        create function dbo.UFN_SELECTION_REVENUE_LEGACYHELDRECURRINGGIFTS()
        returns @IDS table (ID uniqueidentifier)
        as 
        begin
            insert into @IDS (ID)
            select f.ID
      from dbo.FINANCIALTRANSACTION f
      inner join dbo.REVENUESCHEDULE s on s.ID = f.ID
      where f.TYPECODE = 2
      and s.STATUSCODE = 1
      and not exists(select 'x'
                     from dbo.RECURRINGGIFTINSTALLMENT i
                     where i.REVENUEID = f.ID
                     and i.STATUSCODE = 3);

            return
        end