USP_EMAILFINDERSUBMITPROCESS_GETPARAMETERS

CREATE procedure dbo.USP_EMAILFINDERSUBMITPROCESS_GETPARAMETERS
(
    @ID uniqueidentifier
)
as
begin
    select
        EMAILFINDER.SITEID,
        EMAILFINDER.ID as EMAILFINDERID,
        EMAILFINDER.NAME,
        EMAILFINDERSUBMITPROCESS.IDSETREGISTERID,
        EMAILFINDERSUBMITPROCESS.ADDRESSINCLUDECODE,
        EMAILFINDERSUBMITPROCESS.ADDRESSTYPECODEID,
        EMAILFINDERSUBMITPROCESS.SUBMITHOUSEHOLD,
        EMAILFINDERSUBMITPROCESS.INCLUDEINACTIVE,
        EMAILFINDERSUBMITPROCESS.INCLUDEINCOMPLETEADDRESSES,
        EMAILFINDERSUBMITPROCESS.CREATEOUTPUTIDSET,
        EMAILFINDERSUBMITPROCESS.OUTPUTIDSETNAME,
        EMAILFINDERSUBMITPROCESS.OVERWRITEOUTPUTIDSET,
        EMAILFINDERSUBMITPROCESS.OUTPUTIDSETRECORDTYPEID,
        INSTALLATIONINFO.INSTALLATIONNAME,
        INSTALLATIONINFO.SERIALNUMBER,
        EMAILFINDER.PRIMARYCONTACTNAME,
        EMAILFINDER.PRIMARYCONTACTEMAIL,
        EMAILFINDER.PRIMARYCONTACTPHONE,
        EMAILFINDER.ALTERNATECONTACTNAME,
        EMAILFINDER.ALTERNATECONTACTEMAIL,
        EMAILFINDER.ALTERNATECONTACTPHONE,
        EMAILFINDER.BATCHID,
        EMAILFINDER.BATCHAPPUSERID,
        EMAILFINDERSUBMITPROCESS.CREATENEWBATCH,
        EMAILFINDER.OPTOUTDEFAULTEMAIL
    from
        dbo.EMAILFINDERSUBMITPROCESS
    inner join
        dbo.EMAILFINDER on EMAILFINDER.ID = EMAILFINDERSUBMITPROCESS.EMAILFINDERID
    cross join
        dbo.INSTALLATIONINFO
    where
        EMAILFINDERSUBMITPROCESS.ID = @ID
end