here is the X_plan after i done stats on affected tables and indexes.

Plan
--------------------------------------------------------------------------
SELECT STATEMENT
SORT ORDER BY
HASH JOIN SEMI
HASH JOIN
HASH JOIN
TABLE ACCESS FULL PERSON
VIEW VW_SQ_1
SORT GROUP BY
INDEX FAST FULL SCAN REGIMEN_PRES_PK
TABLE ACCESS FULL REGIMEN_PRES
VIEW VW_NSO_2
HASH JOIN
HASH JOIN
TABLE ACCESS FULL PERSON
TABLE ACCESS FULL JOB_QUEUE
INDEX FAST FULL SCAN REGIMEN_PRES_QX28

16 rows selected.

Same thing it shows nothing changed.