USP_RECURRINGGIFT_ADDMISSINGINSTALLMENTS_BASIC

create procedure dbo.USP_RECURRINGGIFT_ADDMISSINGINSTALLMENTS_BASIC (
  @REVENUEID uniqueidentifier,
  @CHANGEAGENTID uniqueidentifier = null,
  @CURRENTDATE datetime = null,
  @ASOFDATE date = null
)
as
begin
    if @CHANGEAGENTID is null
    exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

  if @CURRENTDATE is null
    set @CURRENTDATE = getdate();

  declare @RGAMOUNT money;
  declare @RGTRANSACTIONAMOUNT money;
  declare @RGORGANIZATIONAMOUNT money;
  declare @RGTRANSACTIONCURRENCYID uniqueidentifier;
  declare @RGBASECURRENCYID uniqueidentifier;
  declare @RGBASEEXCHANGERATEID uniqueidentifier;
  declare @RGORGANIZATIONEXCHANGERATEID uniqueidentifier;

  select
    @RGAMOUNT = AMOUNT,
    @RGTRANSACTIONAMOUNT = TRANSACTIONAMOUNT,
    @RGORGANIZATIONAMOUNT = ORGANIZATIONAMOUNT,
    @RGTRANSACTIONCURRENCYID = TRANSACTIONCURRENCYID,
    @RGBASECURRENCYID = BASECURRENCYID,
    @RGBASEEXCHANGERATEID = BASEEXCHANGERATEID,
    @RGORGANIZATIONEXCHANGERATEID = ORGANIZATIONEXCHANGERATEID
  from dbo.REVENUE
  where ID = @REVENUEID;

  exec dbo.USP_RECURRINGGIFT_ADDMISSINGINSTALLMENTS
    @REVENUEID,
    @CHANGEAGENTID,
    @CURRENTDATE,
    @RGAMOUNT,
    null,
    @RGBASECURRENCYID,
    @RGORGANIZATIONAMOUNT,
    @RGORGANIZATIONEXCHANGERATEID,
    @RGTRANSACTIONAMOUNT,
    @RGTRANSACTIONCURRENCYID,
    @RGBASEEXCHANGERATEID,
    @ASOFDATE
end