I need to select all the employees under a manager in a particular span of time period. Say I need to select full span of employees who were under "12345" between 01/JAN/2009 to 07/MAR/2009. Employees who were under "12345" only till 05/JAN/2009 and got shifted to another department should also get listed in the output and same case for terminated employee. I am using the below SQL, but its not fetching correct employee. Pls let me know how to achive this.

Select a.emplid, a.supervisor_id from PS_job a
START WITH a.supervisor_id = '12345'
CONNECT BY PRIOR a.emplid = a.supervisor_id
and a.empl_status in ('A','L','P','S')
and a.effdt = ( (Select Max(Effdt) from
ps_job where emplid = a.emplid
and empl_rcd = a.empl_rcd and effdt <= 07/MAR/2009)

or a.effdt = (Select Max(Effdt) from ps_job
where emplid = a.emplid and empl_rcd = a.empl_rcd
and (effdt >= 01/JAN/2009 and effdt <= 07/MAR/2009)
and a.empl_status in ('A','L','P','S')))