WIP Employee Rates Listing

select    (round(w1.hourly_labor_rate, :p_precision)) hourly_labor_rate
,         w1.effective_date
,         w1.employee_id
from      wip_employee_labor_rates w1
where     w1.effective_date != 
              (SELECT  NVL(MAX(w2.effective_date),SYSDATE)
               FROM    wip_employee_labor_rates w2
               WHERE   w2.employee_id = w1.employee_id
               AND     w2.organization_id = :P_Organization_Id
               AND     w2.effective_date <= SYSDATE)
and       w1.organization_id = :P_Organization_Id 
&Limit_Dates 
 and w1.employee_id=:EMPLOYEE_ID_Q_Emp
order by  w1.employee_id, w1.effective_date desc

select (round(w1.hourly_labor_rate, :p_precision)) hourly_labor_rate , w1.effective_date , w1.employee_id from wip_employee_labor_rates w1 where w1.effective_date != (SELECT NVL(MAX(w2.effective_date),SYSDATE) FROM wip_employee_labor_rates w2 WHERE w2.employee_id = w1.employee_id AND w2.organization_id = :P_Organization_Id AND w2.effective_date <= SYSDATE) and w1.organization_id = :P_Organization_Id &Limit_Dates and w1.employee_id=:EMPLOYEE_ID_Q_Emp order by w1.employee_id, w1.effective_date desc