UFN_PDACCOUNT_GETAPPEALID_3

Return

Return Type
uniqueidentifier

Parameters

Parameter Parameter Type Mode Description
@REVENUEINFORMATION xml IN

Definition

Copy


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

                select top 1 @RESULT = REVENUEINFORMATION.APPEALID 
                from dbo.UFN_REVENUEINFORMATION_FROMITEMLISTXML(@REVENUEINFORMATION) as REVENUEINFORMATION;

                return @RESULT;
            end