USP_REVENUEDETAIL_SETSENDBENEFITCODE

Updates sendbenefitcode for a given revenue record.

Parameters

Parameter	Parameter Type	Mode	Description
@REVENUEID	uniqueidentifier	IN
@OVERRIDE	bit	IN

Definition

Copy



CREATE procedure dbo.USP_REVENUEDETAIL_SETSENDBENEFITCODE
    (
        @REVENUEID uniqueidentifier,
        @OVERRIDE bit
    )
as
begin
    if @OVERRIDE = 1
        update dbo.REVENUEBENEFIT_EXT 
        set SENDBENEFIT = 0 
        from dbo.FINANCIALTRANSACTIONLINEITEM inner join REVENUEBENEFIT_EXT on FINANCIALTRANSACTIONLINEITEM.ID = REVENUEBENEFIT_EXT.ID
        where FINANCIALTRANSACTIONLINEITEM.FINANCIALTRANSACTIONID = @REVENUEID
    else
        update dbo.REVENUEBENEFIT_EXT 
        set SENDBENEFIT = (select SENDBENEFITCODE from BENEFIT where BENEFIT.ID = REVENUEBENEFIT_EXT.BENEFITID) 
        from dbo.FINANCIALTRANSACTIONLINEITEM inner join REVENUEBENEFIT_EXT on FINANCIALTRANSACTIONLINEITEM.ID = REVENUEBENEFIT_EXT.ID
        where FINANCIALTRANSACTIONLINEITEM.FINANCIALTRANSACTIONID = @REVENUEID
end