USP_REVENUE_CLEARCAMPAIGNS

            CREATE procedure dbo.USP_REVENUE_CLEARCAMPAIGNS
            (
                @REVENUEID uniqueidentifier,
                @CHANGEAGENTID uniqueidentifier
            )
            as
                set nocount on

                if @CHANGEAGENTID is null
                    exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output

                declare @contextCache varbinary(128)

                --cache current context information

                set @contextCache = CONTEXT_INFO()

                --set CONTEXT_INFO to @CHANGEAGENTID

                set CONTEXT_INFO @CHANGEAGENTID

                delete from dbo.REVENUESPLITCAMPAIGN
                where REVENUESPLITID in (select ID from dbo.FINANCIALTRANSACTIONLINEITEM where FINANCIALTRANSACTIONID = @REVENUEID)

                --reset CONTEXT_INFO to previous value

                if not @contextCache is null
                    set CONTEXT_INFO @contextCache