USP_ADDRESSVALIDATIONPROCESS_GETPARAMETERS

create procedure dbo.USP_ADDRESSVALIDATIONPROCESS_GETPARAMETERS
(
    @ID uniqueidentifier = null
)
as
    set nocount on;    

    select ADDRESSVALIDATION.SITEID,
        ADDRESSVALIDATION.ID as ADDRESSVALIDATIONID,
        ADDRESSVALIDATION.NAME,    
        ADDRESSVALIDATION.BATCHID,
        ADDRESSVALIDATION.BATCHAPPUSERID,
        PROCESS.IDSETREGISTERID,
        PROCESS.INCLUDECONSTITUENTDNM,
        PROCESS.ADDRESSINCLUDECODE,
        PROCESS.ADDRESSTYPECODEID,
        PROCESS.INCLUDEADDRESSESDNM,
        PROCESS.CREATEOUTPUTIDSET,
        PROCESS.OUTPUTIDSETNAME,
        PROCESS.OVERWRITEOUTPUTIDSET,
        PROCESS.OUTPUTIDSETRECORDTYPEID,            
        PROCESS.CREATENEWBATCH
    from dbo.ADDRESSVALIDATIONPROCESS PROCESS
    inner join dbo.ADDRESSVALIDATION on ADDRESSVALIDATION.ID = PROCESS.ADDRESSVALIDATIONID
    where PROCESS.ID = @ID;