Due to dynamic SQL, and wrapped code, it’s really tough/impossible to be able to generate a 100% accurate CRUD matrix.
But if I had the task of locating objects that update a certain column, I think I’d start with a query like the one below against DBA_SOURCE. You’ll still have to do some manual searching after that, but this should narrow it down. You could add an additional subquery with UPDATE in there if you wanted, but you get the idea.
from dba_source src
where (src.TEXT) like ‘%DEPTNO%’ – or whatever your column is called
and (owner, name) in (select distinct owner, name
where upper(text) like ‘%EMP%’) – or whatever your table is called
and (owner, name) not in (select distinct owner, name
where line = 1
and text like lower(type) || ’ ’ || lower(name) || ’ wrapped%’);