USP_PHONEFINDERSUBMITPROCESS_GETPARAMETERS

CREATE procedure dbo.USP_PHONEFINDERSUBMITPROCESS_GETPARAMETERS
(
    @ID uniqueidentifier
)
as
begin
    set nocount on;

    select
        INSTALLATIONINFO.[INSTALLATIONNAME],
        INSTALLATIONINFO.[SERIALNUMBER],
        PHONEFINDER.[PRIMARYCONTACTNAME],
        PHONEFINDER.[PRIMARYCONTACTEMAIL],
        PHONEFINDER.[PRIMARYCONTACTPHONE],
        PHONEFINDER.[ALTERNATECONTACTNAME],
        PHONEFINDER.[ALTERNATECONTACTEMAIL],
        PHONEFINDER.[ALTERNATECONTACTPHONE],
        PHONEFINDERSUBMITPROCESS.[IDSETREGISTERID],
        PHONEFINDERSUBMITPROCESS.[INDIVIDUALADDRESSINCLUDECODE],
        PHONEFINDERSUBMITPROCESS.[INDIVIDUALADDRESSTYPECODEID],
        PHONEFINDERSUBMITPROCESS.[ORGANIZATIONADDRESSINCLUDECODE],
        PHONEFINDERSUBMITPROCESS.[ORGANIZATIONADDRESSTYPECODEID],
        PHONEFINDERSUBMITPROCESS.[INDIVIDUALPHONENUMBERINCLUDECODE],
        PHONEFINDERSUBMITPROCESS.[INDIVIDUALPHONETYPECODEID],
        PHONEFINDERSUBMITPROCESS.[ORGANIZATIONPHONENUMBERINCLUDECODE],
        PHONEFINDERSUBMITPROCESS.[ORGANIZATIONPHONETYPECODEID],
        PHONEFINDERSUBMITPROCESS.[INCLUDEINACTIVE],
        PHONEFINDERSUBMITPROCESS.[INCLUDEINCOMPLETEADDRESSES],
        PHONEFINDERSUBMITPROCESS.[CREATEOUTPUTIDSET],
        PHONEFINDERSUBMITPROCESS.[OUTPUTIDSETNAME],
        PHONEFINDERSUBMITPROCESS.[OVERWRITEOUTPUTIDSET],
        PHONEFINDERSUBMITPROCESS.[CREATENEWBATCH],
        PHONEFINDER.[NAME],
        PHONEFINDER.[BATCHID],
        PHONEFINDER.[BATCHAPPUSERID],
        PHONEFINDER.[SITEID],
    PHONEFINDERSUBMITPROCESS.[INCLUDECONSTITUENTDNM]
    from
        dbo.PHONEFINDERSUBMITPROCESS
        inner join dbo.PHONEFINDER on PHONEFINDER.[ID] = PHONEFINDERSUBMITPROCESS.[PHONEFINDERID]
        cross join dbo.INSTALLATIONINFO
    where
        PHONEFINDERSUBMITPROCESS.[ID] = @ID;

end