Oracle Message PLS-00388 - undefined column string in subquery

ERRORundefined column string in subquery
CAUSEA subquery contains a column name that was not defined in the specified table.
ACTIONChange the expression to specify a column that was defined.