Please note just creating the stored procedure will not bring the table names being used within the stored procedure.

To get the list of table names being used with the above said logic, the stored procedure should have been executed at least once. For e.g Exec your_sp_name parameters.