UFN_PDACCOUNT_GETAPPLICATIONSEGMENT_3

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

                select @RESULT = PDAPPLICATIONSEGMENT.ID 
                from PDAPPLICATIONSEGMENT 
                    inner join dbo.UFN_REVENUESPLITINFORMATION_FROMITEMLISTXML(@REVENUESPLITINFORMATION) as REVENUESPLITINFORMATION
                        on PDAPPLICATIONSEGMENT.APPLICATIONVALUE = REVENUESPLITINFORMATION.APPLICATIONCODE;

                return @RESULT;
            end