UFN_RECURRINGGIFTSETTING_GETFOREFFECTIVEDATE

CREATE function dbo.UFN_RECURRINGGIFTSETTING_GETFOREFFECTIVEDATE(
  @EFFECTIVEDATE datetime
)
returns table
as return
  select top 1 FIRSTINSTALLMENTCODE,
               INSTALLMENTUNDERPAYMENTCODE,
               APPLYTOPASTINSTALLMENTS,
               PASTBALANCEUNDERPAYMENTCODE,
               OVERPAYMENTCODE,
               UPGRADEDATE,
               ISRGPAYMENTHANDLINGBATCH
  from dbo.RECURRINGGIFTSETTING
  where EFFECTIVEDATE < @EFFECTIVEDATE
  order by EFFECTIVEDATE desc;