USP_EDIT_REVENUE_RECALC_DEPOSIT_BALANCE

Updates the deposit balance associated with a revenue record

Parameters

Parameter	Parameter Type	Mode	Description
@REVENUEID	uniqueidentifier	IN

Definition

Copy



CREATE procedure dbo.USP_EDIT_REVENUE_RECALC_DEPOSIT_BALANCE
(
    @REVENUEID uniqueidentifier
)
as 
    set nocount on;

  --This stored procedure has been deprecated and should no longer be used anywhere


    --declare @DEPOSITID uniqueidentifier;


    --SELECT TOP 1 @DEPOSITID=DEPOSITID FROM dbo.BANKACCOUNTDEPOSITPAYMENT WHERE ID=@REVENUEID;


    --if NOT @DEPOSITID IS NULL BEGIN

    --    UPDATE dbo.BANKACCOUNTTRANSACTION 

    --    SET AMOUNT=dbo.UFN_BANKACCOUNTDEPOSIT_GETDEPOSITAMOUNT(@DEPOSITID) 

    --    WHERE ID=@DEPOSITID 

    --END