USP_REVALUECOMMITMENTSPROCESS_GETPARAMETERS

Retrieves parameter settings for a given revalue commitments process parameter set.
Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN
Definition

Copy


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

                select 
                    NAME,
                    REVALUEBYTYPECODE,
                    INCLUDEGRANTAWARDS,
                    INCLUDEPLANNEDGIFTS,
                    INCLUDEPLEDGES,
                    INCLUDERECURRINGGIFTS,
                    IDSETREGISTERID, 
                    CURRENCYEXCHANGERATEASOFTYPECODE,
                    CURRENCYEXCHANGERATEASOFDATETIMEOFFSET,
                    TIMEZONEENTRYID,
                    CURRENCYEXCHANGERATESOURCECODEID,
                    ADJUSTMENTDATE,
                    ADJUSTMENTPOSTDATE,
                    ADJUSTMENTPOSTSTATUSCODE,
                    ADJUSTMENTREASONCODEID,
                    ADJUSTMENTREASON,
                    CREATEOUTPUTIDSET,
                    OUTPUTIDSETRECORDTYPEID,
                    OUTPUTIDSETNAME, 
                    OVERWRITEOUTPUTIDSET,
                    CREATEEXCEPTIONIDSET,
                    EXCEPTIONIDSETNAME,
                    OVERWRITEEXCEPTIONIDSET,
                    USEEXCHANGERATEDATEFORADJUSTMENTDATES,
                    INCLUDEINSTALLMENTPLANS
                from 
                    dbo.REVALUECOMMITMENTSPROCESS 
                where 
                    ID = @ID;