DBA Data[Home] [Help]

APPS.WIP_DEFAULT_RES dependencies on WIP_EMPLOYEE_LABOR_RATES

Line 637: from wip_employee_labor_rates we

633: g_Res_rec.organization_id IS NOT NULL) THEN
634:
635: select we.hourly_labor_rate
636: into l_actual_resource_rate
637: from wip_employee_labor_rates we
638: where we.employee_id = g_Res_rec.employee_id
639: and we.organization_id = g_Res_rec.organization_id
640: and we.effective_date = (select max(we1.effective_date)
641: from wip_employee_labor_rates we1

Line 641: from wip_employee_labor_rates we1

637: from wip_employee_labor_rates we
638: where we.employee_id = g_Res_rec.employee_id
639: and we.organization_id = g_Res_rec.organization_id
640: and we.effective_date = (select max(we1.effective_date)
641: from wip_employee_labor_rates we1
642: where we1.effective_date < sysdate
643: and we1.employee_id = g_Res_rec.employee_id
644: and we1.organization_id = g_Res_rec.organization_id);
645: