WIP Employee Rates Listing

Description
Categories: BI Publisher, Manufacturing
Application: Work in Process
Source: Employee Rates Listing (XML)
Short Name: WIPSUEMP_XML
DB package: WIP_WIPSUEMP_XMLP_PKG
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
Parameter Name SQL text Validation
Organization Id
 
Number
To
 
Date
Dates From
 
Date
To
 
LOV Oracle
Employees From
 
LOV Oracle
Current Only
 
LOV Oracle
Display in Detail
 
LOV Oracle