Anybody know the proper syntax for the following SELECT statement, where p_PayeeName is a public variable. As it is now, it isn't searching for the value of the variable.

SELECT payee_code, payee_name;
FROM wc!payee2;
WHERE payee2.payee_name like '%p_PayeeName%';
ORDER BY payee_name