USP_PEOPLEFINDERSUBMITPROCESS_GETPARAMETERS

CREATE procedure dbo.USP_PEOPLEFINDERSUBMITPROCESS_GETPARAMETERS
(
    @ID uniqueidentifier
)
as
begin

    select
        PEOPLEFINDER.SITEID,
        PEOPLEFINDER.ID as PEOPLEFINDERID,
        PEOPLEFINDER.NAME,
        PEOPLEFINDERSUBMITPROCESS.IDSETREGISTERID,
        PEOPLEFINDERSUBMITPROCESS.ADDRESSINCLUDECODE,
        PEOPLEFINDERSUBMITPROCESS.ADDRESSTYPECODEID,
        PEOPLEFINDERSUBMITPROCESS.INCLUDEINACTIVE,
        PEOPLEFINDERSUBMITPROCESS.INCLUDEINCOMPLETEADDRESSES,
        PEOPLEFINDERSUBMITPROCESS.CREATEOUTPUTIDSET,
        PEOPLEFINDERSUBMITPROCESS.OUTPUTIDSETNAME,
        PEOPLEFINDERSUBMITPROCESS.OVERWRITEOUTPUTIDSET,
        PEOPLEFINDERSUBMITPROCESS.OUTPUTIDSETRECORDTYPEID,
        INSTALLATIONINFO.INSTALLATIONNAME,
        INSTALLATIONINFO.SERIALNUMBER,
        PEOPLEFINDER.PRIMARYCONTACTNAME,
        PEOPLEFINDER.PRIMARYCONTACTEMAIL,
        PEOPLEFINDER.PRIMARYCONTACTPHONE,
        PEOPLEFINDER.ALTERNATECONTACTNAME,
        PEOPLEFINDER.ALTERNATECONTACTEMAIL,
        PEOPLEFINDER.ALTERNATECONTACTPHONE,
        PEOPLEFINDER.BATCHID,
        PEOPLEFINDER.BATCHAPPUSERID,
        PEOPLEFINDERSUBMITPROCESS.CREATENEWBATCH
    from
        dbo.PEOPLEFINDERSUBMITPROCESS
    inner join
        dbo.PEOPLEFINDER on PEOPLEFINDER.ID = PEOPLEFINDERSUBMITPROCESS.PEOPLEFINDERID
    cross join
        dbo.INSTALLATIONINFO
    where
        PEOPLEFINDERSUBMITPROCESS.ID = @ID

end