UFN_RECURRINGGIFTSETTING

Return

Return Type
table
Parameters

Parameter	Parameter Type	Mode	Description
@EFFECTIVEDATE	datetime	IN
Definition

Copy


CREATE function dbo.UFN_RECURRINGGIFTSETTING(
  @EFFECTIVEDATE datetime
)
returns @SETTINGS table (
  FIRSTINSTALLMENTCODE tinyint,
  INSTALLMENTUNDERPAYMENTCODE tinyint,
  APPLYTOPASTINSTALLMENTS bit,
  PASTBALANCEUNDERPAYMENTCODE tinyint,
  OVERPAYMENTCODE tinyint,
  UPGRADEDATE datetime,
  ISRGPAYMENTHANDLINGBATCH bit
)
as begin
  if @EFFECTIVEDATE is null
    insert into @SETTINGS
    select FIRSTINSTALLMENTCODE,
           INSTALLMENTUNDERPAYMENTCODE,
           APPLYTOPASTINSTALLMENTS,      
           PASTBALANCEUNDERPAYMENTCODE,
           OVERPAYMENTCODE,
           UPGRADEDATE,
           ISRGPAYMENTHANDLINGBATCH
    from dbo.UFN_RECURRINGGIFTSETTING_GETCURRENT();

  else
    insert into @SETTINGS
    select FIRSTINSTALLMENTCODE,
           INSTALLMENTUNDERPAYMENTCODE,
           APPLYTOPASTINSTALLMENTS,      
           PASTBALANCEUNDERPAYMENTCODE,
           OVERPAYMENTCODE,
           UPGRADEDATE,
           ISRGPAYMENTHANDLINGBATCH
    from dbo.UFN_RECURRINGGIFTSETTING_GETFOREFFECTIVEDATE(@EFFECTIVEDATE);

  return;
end