USP_COAUPDATERESUBMITPROCESS_GETPARAMETERS

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

                select COAUPDATE.ID as COAUPDATEID,
                    COAUPDATEFILE.REQUESTFILE,
                    COAUPDATE.FILENAME,
                    COAUPDATE.FILEUPLOADED,
                    COAUPDATE.FILEDOWNLOADED
                from dbo.COAUPDATERESUBMITPROCESS RESUBMIT
                inner join dbo.COAUPDATE on COAUPDATE.ID = RESUBMIT.COAUPDATEID
                inner join dbo.COAUPDATEFILE on COAUPDATE.ID = COAUPDATEFILE.ID
                where RESUBMIT.ID = @ID;