USP_GETPENDINGTRANSFERSPONSORSHIPS

Retrieve the from and to sponsorships of a pending transfer, given either of the sponsorships.

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@FROMSPONSORSHIPID	uniqueidentifier	INOUT
@TOSPONSORSHIPID	uniqueidentifier	INOUT

Definition

Copy



CREATE procedure dbo.USP_GETPENDINGTRANSFERSPONSORSHIPS
    @ID uniqueidentifier,
    @FROMSPONSORSHIPID uniqueidentifier output,
    @TOSPONSORSHIPID uniqueidentifier output
as
begin
    select @FROMSPONSORSHIPID = T1.CONTEXTSPONSORSHIPID,
           @TOSPONSORSHIPID = T1.TARGETSPONSORSHIPID
    from dbo.SPONSORSHIPTRANSACTION T1
  inner join dbo.SPONSORSHIP S on S.SPONSORSHIPCOMMITMENTID = T1.SPONSORSHIPCOMMITMENTID
    where T1.TRANSACTIONSEQUENCE = (select max(TRANSACTIONSEQUENCE)
                                    from dbo.SPONSORSHIPTRANSACTION
                                    where SPONSORSHIPCOMMITMENTID = S.SPONSORSHIPCOMMITMENTID
                                    and SPONSORSHIPTRANSACTION.ACTIONCODE <> 9)
    and T1.ACTIONCODE = 6
  and S.ID = @ID
end