Query to know what are all the tables that has been used inside the procedure?
You can use the following to see on what objects your procedure depends:
SELECT REFERENCED_TYPE, REFERENCED_OWNER, REFERENCED_NAME
WHERE TYPE = 'PROCEDURE'
AND NAME = '&your_procedure_name'
If you want to see tables only, then you can add the condition
... AND REFERENCED_TYPE = 'TABLE'
However, please be aware that this statement *WILL NOT* return tables that
have been accessed inside the procedure using dynamic SQL statement.
Sign up for STechies