Can Table1 In Example Below Get Updated By Another Process While The Transaction Is In Progress?

I am afraid that just after @statusOfEmployee is retrieved from table1, but before table2 is updated, someone else (a second user) calls this same stored procedure and changes the @statusOfEmployee value. This would create an inconsistent update of table2 by first user, since the update of table2 'might' not have gone ahead if the latest value of @statusOF Employee was used. CAN SOMEONE PLEASE HELP ME WITH THIS SITUATION AND HOW I CAN BE SURE THAT ABOVE DOES NOT HAPPEN SINCE MULTIPLE USERS WILL BE HITTING THIS STORED PROCEDURE?

 

declare @status int
begin tran
set @status = (select statusOfEmployee from table1)
if @@ERROR = 0
   begin
    update table2
        set destination = @destination /* @destination is an input parameter passed to the sp*/
        where @currentStatus = @status
   if @ERROR = 0
      commit tran
   else
      rollback tran
   end
else
     rollback tran

return