To find the table name by using the column name

To find the table name by using the column name:

select * from all_tab_columns where Upper(column_name) like Upper('Payment%Method%');

Payment%Method% is the column name