USP_DECEASEDFINDERSUBMITPROCESS_GETPARAMETERS

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

      exec dbo.USP_GET_KEY_ACCESS;

      select 
        DECEASEDFINDER.SITEID,
        DECEASEDFINDER.ID as DECEASEDFINDERID,
        DECEASEDFINDER.NAME,
        SUBMIT.IDSETREGISTERID,
        SUBMIT.ADDRESSINCLUDECODE,
        SUBMIT.ADDRESSTYPECODEID,
        SUBMIT.INCLUDEADDRESSESDNM,
        SUBMIT.CREATEOUTPUTIDSET,
        SUBMIT.OUTPUTIDSETNAME,
        SUBMIT.OVERWRITEOUTPUTIDSET,
        SUBMIT.OUTPUTIDSETRECORDTYPEID,
        INSTALL.INSTALLATIONNAME,
        INSTALL.SERIALNUMBER,
        DECEASEDFINDER.PRIMARYCONTACTNAME,
        DECEASEDFINDER.PRIMARYCONTACTEMAIL,
        DECEASEDFINDER.PRIMARYCONTACTPHONE,
        DECEASEDFINDER.ALTERNATECONTACTNAME,
        DECEASEDFINDER.ALTERNATECONTACTEMAIL,
        DECEASEDFINDER.ALTERNATECONTACTPHONE,
        DECEASEDFINDER.BATCHID,
        DECEASEDFINDER.BATCHAPPUSERID,
        SUBMIT.CREATENEWBATCH,
        SABOTEN.USERNAME as SABOTENUSERNAME,
        convert(nvarchar(250), DecryptByKey(SABOTEN.SECRETKEY)) as SABOTENSECRETKEY,
        INSTALL.CLARIFYSITEID,
        SABOTEN.NAICS,
        SABOTEN.ADDRESS,
        SABOTEN.CITY,
        SABOTEN.POSTCODE,
        STATE.ABBREVIATION [STATEABBREVIATION],
        TITLECODE.DESCRIPTION [PRIMARYCONTACTTITLE],
        DECEASEDFINDER.CONTACTJOBTITLE [CONTACTJOBTITLE]
      from 
        dbo.DECEASEDFINDERSUBMITPROCESS SUBMIT
      inner join 
        dbo.DECEASEDFINDER 
      on 
        DECEASEDFINDER.ID = SUBMIT.DECEASEDFINDERID
      left join dbo.[TITLECODE] on [TITLECODE].[ID] = [DECEASEDFINDER].[PRIMARYCONTACTTITLECODEID]
      cross join 
        dbo.INSTALLATIONINFO INSTALL
      cross join dbo.SABOTEN
      left join dbo.[STATE] on [STATE].[ID] = [SABOTEN].[STATEID]
      where 
        SUBMIT.ID = @ID;