If the manager has not approved a timesheet modification before payroll is run, what happens?

Only the approved (Final) transactions will get picked up by Payroll. Version 1 (original) is the Final version of the transaction until the Modification (version 2) is approved. If the Modification version is not approved, the original timesheet transaction will be processed.