USP_PRENOTIFICATIONPROCESS_GETPARAMETERS

Retrieves parameter settings for a given prenotification process parameter set.

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN

Definition

Copy



            CREATE procedure dbo.USP_PRENOTIFICATIONPROCESS_GETPARAMETERS
            (
                @ID uniqueidentifier = null
            )
            as
                set nocount on;

                select 
                    NAME, 
                    IDSETREGISTERID, 
                    CREATEOUTPUTIDSET, 
                    OUTPUTIDSETNAME, 
                    OVERWRITEOUTPUTIDSET,
                    BANKACCOUNTID
                from 
                    dbo.PRENOTIFICATIONPROCESS 
                where 
                    ID = @ID;