Does this stored proc really give the occurence of a value in the database or the occurence of a attribute/field name in the database ?

I have a value and I need to check all the tables in the database where this value is present. Is there a way to get all the tables and column names in which the value is present?