Can I query the system tables to find out if a particular column is used by any plan/package?

SYSPACKDEP will show the package dependencies at the table/view/synonym/tablespace/index/alias/function/stored procedure level. You can query the STMT column of the SYSPACKSTMT and look for references to the column name in the associated sql statement unless the column is not explicitly named in the statement.