find all tables in server with specific column name

select       *
from         information_schema.columns  C
where
                COLUMN_NAME like '%COLUMN_NAME %'

list of stored pocs with specific table name

SELECT Name

FROM sys.procedures

WHERE OBJECT_DEFINITION(OBJECT_ID) LIKE '%table name%'

------Example-------

SELECT Name

FROM sys.procedures

WHERE OBJECT_DEFINITION(OBJECT_ID) LIKE '%account_total%'