USP_DECEASEDFINDERCREATEPROCESS_GETPARAMETERS

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

      exec dbo.USP_GET_KEY_ACCESS;

      select 
        DECEASEDFINDER.SITEID,
        DECEASEDFINDER.ID as DECEASEDFINDERID,
        DECEASEDFINDER.NAME,
        [CREATE].IDSETREGISTERID,
        [CREATE].ADDRESSINCLUDECODE,
        [CREATE].ADDRESSTYPECODEID,
        [CREATE].INCLUDEADDRESSESDNM,
        [CREATE].CREATEOUTPUTIDSET,
        [CREATE].OUTPUTIDSETNAME,
        [CREATE].OVERWRITEOUTPUTIDSET,
        [CREATE].OUTPUTIDSETRECORDTYPEID,
        INSTALL.INSTALLATIONNAME,
        INSTALL.SERIALNUMBER,
        DECEASEDFINDER.PRIMARYCONTACTNAME,
        DECEASEDFINDER.PRIMARYCONTACTEMAIL,
        DECEASEDFINDER.PRIMARYCONTACTPHONE,
        DECEASEDFINDER.ALTERNATECONTACTNAME,
        DECEASEDFINDER.ALTERNATECONTACTEMAIL,
        DECEASEDFINDER.ALTERNATECONTACTPHONE,
        DECEASEDFINDER.BATCHID,
        DECEASEDFINDER.BATCHAPPUSERID,
        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]    
      from 
        dbo.DECEASEDFINDERCREATEPROCESS [CREATE]
      inner join 
        dbo.DECEASEDFINDER 
      on 
        DECEASEDFINDER.ID = [CREATE].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 
        [CREATE].ID = @ID;