PLS-01467: The value list of the IN predicate, if not a subquery, must contain only value_specifications
Cause: The value list of the IN predicate, if not a subquery, must contain only value_specifications (that is, literals and PL/SQL or embedded variables).
Action: Refer to ANSI document ANSI X3.135-1992 for details.