UFN_PDACCOUNT_GETCHANNELCODE_3

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

                select @RESULT = REVENUEINFORMATION.CHANNELCODEID 
                from dbo.UFN_REVENUEINFORMATION_FROMITEMLISTXML(@REVENUEINFORMATION) as REVENUEINFORMATION;

                return @RESULT;
            end