When using an equation to get a date in a SQL, like the one below, the optimzer returns a message saying, "The Parser did not identify the text as a valid SQL statement".
SELECT *
FROM DUAL
WHERE 'N' = CBC_GETSHIFT(SYSDATE -(:P10_HOURSDIFF1 / 24), 'N')