USP_DATAFORMTEMPLATE_ADD_PRELOAD_SIGNATURE

CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_PRELOAD_SIGNATURE
(
  @APPLICATIONTYPEINFORMATION xml = null output
)
as
begin
    set nocount on;

    set @APPLICATIONTYPEINFORMATION =
  (
    select 
      SIGNATUREAPPLICATIONTYPE.ID as SIGNATUREAPPLICATIONTYPEID,
      SIGNATUREAPPLICATIONTYPE.TYPE as SIGNATUREAPPLICATIONTYPENAME
    from dbo.SIGNATUREAPPLICATIONTYPE
    where ISACTIVE = 1
    order by SEQUENCE asc
    for xml raw ('ITEM'), type, elements, root('APPLICATIONTYPEINFORMATION'), BINARY BASE64
  )

    return 0;
end