Select A.Employee EEID, C.first_name||''||C.last_name EE_Name, c.Fica_NBR SSN,  b.EBANK_ID Routing,
b.ebnk_ACCT_NBR Account, b.Description Bank_name,
A.effect_date , b.ACH_Prenotify Prenotify_Status,C.process_level,
D.National_name
from PERSACTION A, emachdepst b, Employee c, comprof D where a.employee = b.employee
and a.company= b.company
and a.employee=c.employee
and a.company = c.company
and c.process_level = d.process_level
and c.company = d.company
and A.Action_code = 'DIRECT DEP'
and A.effect_date = 

orclz>
orclz> select sysdate,sysdate-1 from dual;

SYSDATE             SYSDATE-1
------------------- -------------------
2013-11-21 11:35:45 2013-11-20 11:35:45

orclz>