DBA Data[Home] [Help]

APPS.WIP_EAM_RESOURCE_TRANSACTION dependencies on WIP_EMPLOYEE_LABOR_RATES

Line 414: FROM wip_employee_labor_rates

410: if (employee_exists = 1) then
411: BEGIN
412: SELECT hourly_labor_rate
413: INTO x_actual_resource_rate
414: FROM wip_employee_labor_rates
415: WHERE employee_id = l_actual_employee_id
416: AND organization_id = p_organization_id
417: AND effective_date = (
418: SELECT MAX(effective_date)

Line 419: FROM wip_employee_labor_rates

415: WHERE employee_id = l_actual_employee_id
416: AND organization_id = p_organization_id
417: AND effective_date = (
418: SELECT MAX(effective_date)
419: FROM wip_employee_labor_rates
420: WHERE employee_id = l_actual_employee_id
421: AND organization_id = p_organization_id
422: AND effective_date <= sysdate
423: );