USP_DECEASEDFINDERRESUBMITPROCESS_GETPARAMETERS

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

            select 
                DECEASEDFINDER.ID as DECEASEDFINDERID,
                DECEASEDFINDERFILE.REQUESTFILE,
                DECEASEDFINDER.FILENAME,
                DECEASEDFINDER.FILEUPLOADED,
                DECEASEDFINDER.FILEDOWNLOADED
            from 
                dbo.DECEASEDFINDERRESUBMITPROCESS RESUBMIT
            inner join 
                dbo.DECEASEDFINDER 
            on 
                DECEASEDFINDER.ID = RESUBMIT.DECEASEDFINDERID
            inner join 
                dbo.DECEASEDFINDERFILE 
            on 
                DECEASEDFINDER.ID = DECEASEDFINDERFILE.ID
            where 
                RESUBMIT.ID = @ID;