I have got the following cursor

CURSOR entities_to_delete IS
SELECT * FROM tibex_deleteAdmin
WHERE deleteEntityId,deleteEntitytype,timestamp IN (
SELECT deleteEntityId, deleteEntityType, max(timestamp) timestamp
FROM tibex_deleteAdmin
GROUP BY deleteEntityId, deleteEntitytype
)
AND deleteAction=(
SELECT deleteAction
FROM tibex_deleteActionEnum
WHERE ShortDesc='DA_DEL'
)
ORDER by timestamp;

I get an error ORA-00920: invalid relational operator,

I know it's something basic on line
WHERE deleteEntityId,deleteEntitytype,timestamp IN (

Any ideas...


Thanks in advance