Message Oracle PLS-01467 - The value list of the IN predicate, if not a subquery, must contain only value_specifications

ERRORThe value list of the IN predicate, if not a subquery, must contain only value_specifications
CAUSEThe value list of the IN predicate, if not a subquery, must contain only value_specifications (i.e. literals and PL/SQL or embedded variables).
ACTIONNone