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
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: