USP_PEOPLEFINDERRESUBMITPROCESS_GETPARAMETERS

CREATE procedure dbo.USP_PEOPLEFINDERRESUBMITPROCESS_GETPARAMETERS
(
    @ID uniqueidentifier
)
as
begin
    select 
        PEOPLEFINDER.ID as PEOPLEFINDERID,
        PEOPLEFINDERFILE.REQUESTFILE,
        PEOPLEFINDER.FILENAME,
        PEOPLEFINDER.FILEUPLOADED,
        PEOPLEFINDER.FILEDOWNLOADED
    from 
        dbo.PEOPLEFINDERRESUBMITPROCESS
    inner join 
        dbo.PEOPLEFINDER on PEOPLEFINDER.ID = PEOPLEFINDERRESUBMITPROCESS.PEOPLEFINDERID
    inner join 
        dbo.PEOPLEFINDERFILE on PEOPLEFINDER.ID = PEOPLEFINDERFILE.ID
    where 
        PEOPLEFINDERRESUBMITPROCESS.ID = @ID;

end