Hi

Make your logic in stored procedure and try to use INTERVAL function like...

SELECT CURRENT_DATE - INTERVAL '8' MONTH FROM DUAL;

Hope it will help u.

Kancha