UFN_SPONSORSHIP_GIFTFINANCIALSPONSORID

CREATE function dbo.UFN_SPONSORSHIP_GIFTFINANCIALSPONSORID(
    @SPONSORSHIPID uniqueidentifier
)
returns uniqueidentifier
with execute as caller
as begin
    declare @GIFTFINANCIALSPONSORID uniqueidentifier;

    select top 1 @GIFTFINANCIALSPONSORID = SPONSORSHIPTRANSACTION.GIFTFINANCIALSPONSORID
    from dbo.SPONSORSHIP
    inner join dbo.SPONSORSHIPTRANSACTION on SPONSORSHIPTRANSACTION.SPONSORSHIPCOMMITMENTID = SPONSORSHIP.SPONSORSHIPCOMMITMENTID
    where SPONSORSHIP.ID = @SPONSORSHIPID
    and SPONSORSHIPTRANSACTION.TRANSACTIONSEQUENCE <= (select max(LASTTRANSACTION.TRANSACTIONSEQUENCE) from dbo.SPONSORSHIPTRANSACTION LASTTRANSACTION where SPONSORSHIP.ID in(LASTTRANSACTION.CONTEXTSPONSORSHIPID,LASTTRANSACTION.TARGETSPONSORSHIPID,LASTTRANSACTION.DECLINEDSPONSORSHIPID))
    and SPONSORSHIPTRANSACTION.ACTIONCODE in(0,4,5,9)
    order by SPONSORSHIPTRANSACTION.TRANSACTIONSEQUENCE desc;

    return @GIFTFINANCIALSPONSORID;
end