DBA Data[Home] [Help]

APPS.WIP_DEFAULT_RES dependencies on WIP_EMPLOYEE_LABOR_RATES

Line 641: from wip_employee_labor_rates we

637: g_Res_rec.organization_id IS NOT NULL) THEN
638:
639: select we.hourly_labor_rate
640: into l_actual_resource_rate
641: from wip_employee_labor_rates we
642: where we.employee_id = g_Res_rec.employee_id
643: and we.organization_id = g_Res_rec.organization_id
644: and we.effective_date = (select max(we1.effective_date)
645: from wip_employee_labor_rates we1

Line 645: from wip_employee_labor_rates we1

641: from wip_employee_labor_rates we
642: where we.employee_id = g_Res_rec.employee_id
643: and we.organization_id = g_Res_rec.organization_id
644: and we.effective_date = (select max(we1.effective_date)
645: from wip_employee_labor_rates we1
646: where we1.effective_date < sysdate
647: and we1.employee_id = g_Res_rec.employee_id
648: and we1.organization_id = g_Res_rec.organization_id);
649: