WIP Employee Rates Listing
Description
- Categories
- BI Publisher
- Application
- Work in Process
- Source
- Employee Rates Listing (XML)
- Short Name
- WIPSUEMP_XML
- DB package
- WIP_WIPSUEMP_XMLP_PKG
Imported from BI Publisher
Employee Rates Listing
Employee Rates Listing
SQL 15 lines
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 |
Parameters 6
| Parameter | Type | List of values SQL |
|---|---|---|
| Display in Detail | LOV Oracle | |
| Current Only | LOV Oracle | |
| Employees From | LOV Oracle | |
| To | LOV Oracle | |
| Dates From | Date | |
| To 2 | Date |