USP_REVENUE_UPDATESOLICITORS
Updates solicitor amounts so that they remain valid when a revenue amount changes.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @REVENUEID | uniqueidentifier | IN | |
| @CHANGEAGENTID | uniqueidentifier | IN | |
| @CHANGEDATE | datetime | IN | |
| @OLDSPLITS | xml | IN |
Definition
Copy
CREATE procedure dbo.USP_REVENUE_UPDATESOLICITORS
(
@REVENUEID uniqueidentifier,
@CHANGEAGENTID uniqueidentifier,
@CHANGEDATE datetime,
@OLDSPLITS xml = null
)
as
set nocount on;
declare @OPPORTUNITYID uniqueidentifier
declare @MGSOURCEREVENUEID uniqueidentifier
select @MGSOURCEREVENUEID = RMG.MGSOURCEREVENUEID
from dbo.REVENUEMATCHINGGIFT RMG
where RMG.ID = @REVENUEID
select top 1 @OPPORTUNITYID = RO.OPPORTUNITYID
from dbo.FINANCIALTRANSACTIONLINEITEM
left join dbo.REVENUEOPPORTUNITY RO on RO.ID = FINANCIALTRANSACTIONLINEITEM.ID
left join dbo.OPPORTUNITY O on O.ID = RO.OPPORTUNITYID
left join dbo.PROSPECTPLAN PP on PP.ID = O.PROSPECTPLANID
where FINANCIALTRANSACTIONLINEITEM.FINANCIALTRANSACTIONID = @MGSOURCEREVENUEID;
exec dbo.USP_REVENUE_UPDATESOLICITORS_2 @REVENUEID, @OPPORTUNITYID, @CHANGEAGENTID, @CHANGEDATE, @OLDSPLITS;