UFN_PDACCOUNT_GETCAMPAIGN_3

            create function dbo.UFN_PDACCOUNT_GETCAMPAIGN_3
            (
                @REVENUESPLITINFORMATION xml
            ) returns uniqueidentifier
            As 
            begin
                declare @RESULT as uniqueidentifier;

                select @RESULT = DESIGNATIONCAMPAIGN.CAMPAIGNID 
                from dbo.DESIGNATIONCAMPAIGN
                    inner join dbo.UFN_REVENUESPLITINFORMATION_FROMITEMLISTXML(@REVENUESPLITINFORMATION) as REVENUESPLITINFORMATION
                        on DESIGNATIONCAMPAIGN.DESIGNATIONID = REVENUESPLITINFORMATION.DESIGNATIONID;

                return @RESULT;
            end