USP_FAFEVENTAUTOCHARGE_GETINFOBYREGISTRANTID

CREATE procedure dbo.USP_FAFEVENTAUTOCHARGE_GETINFOBYREGISTRANTID(  
  @ID uniqueidentifier
  ,@REMAININGAMOUNT money = 0 output
  ,@MERCHANTACCOUNTID uniqueidentifier = null output
  ,@APPEALID uniqueidentifier = null output
  ,@DESIGNATIONID uniqueidentifier = null output
  ,@CONSTITUENTID uniqueidentifier = null output
  ,@CARDHOLDERNAME nvarchar(255) = null output
  ,@CREDITTYPECODEID uniqueidentifier = null output
  ,@CREDITCARDPARTIALNUMBER nvarchar(4) = null output
  ,@EXPIRESON dbo.UDT_FUZZYDATE = '00000000' output
  ,@CREDITCARDTOKEN uniqueidentifier = null output
  ,@EVENTID uniqueidentifier = null output
  ,@LOCALCORPID uniqueidentifier = null output
)  
as  
begin  
    -- do work  

    set nocount on;

    declare @AMOUNT money = 0;

    select @EVENTID = R.EVENTID    from dbo.[REGISTRANT] R(nolock)    where R.ID = @ID;

    set @AMOUNT = dbo.UFN_REGISTRANT_GETFUNDRAISINGMINIMUMREMAINING(@ID, @EVENTID);

    select top 1
        @REMAININGAMOUNT = @AMOUNT
        ,@MERCHANTACCOUNTID = dbo.UFN_MERCHANTACCOUNT_GETREGISTRANTMERCHANTACCOUNT(RE.LOCALCORPID, R.EVENTID)
    ,@APPEALID = E.APPEALID
        ,@DESIGNATIONID = isnull(L.DESIGNATIONID, A.DESIGNATIONID)
    ,@CONSTITUENTID = R.CONSTITUENTID
        ,@CARDHOLDERNAME = CC.CARDHOLDERNAME
        ,@CREDITTYPECODEID = CC.CREDITTYPECODEID
        ,@CREDITCARDPARTIALNUMBER = CC.CREDITCARDPARTIALNUMBER
        ,@EXPIRESON = CC.EXPIRESON
        ,@CREDITCARDTOKEN = CC.CREDITCARDTOKEN
    ,@EVENTID = E.ID
    ,@LOCALCORPID = L.ID
    from dbo.[REGISTRANT] R(nolock)
    inner join dbo.[REGISTRANTEXTENSION] RE(nolock) on RE.REGISTRANTID = R.ID
    inner join dbo.[EVENT] E(nolock) on E.ID = R.EVENTID
    inner join dbo.[APPEALDESIGNATION] A(nolock) on A.APPEALID = E.APPEALID and A.ISDEFAULT = 1  
    inner join dbo.[CREDITCARD] CC(nolock) on CC.ID = RE.CREDITCARDID
  left outer join dbo.[LOCALCORP] L(nolock) on L.ID = RE.LOCALCORPID
    where R.ID = @ID;

    return 0;  
end