DBA Data[Home] [Help]

APPS.WIP_EAM_RESOURCE_TRANSACTION dependencies on WIP_EMPLOYEE_LABOR_RATES

Line 418: FROM wip_employee_labor_rates

414: if (employee_exists = 1) then
415: BEGIN
416: SELECT hourly_labor_rate
417: INTO x_actual_resource_rate
418: FROM wip_employee_labor_rates
419: WHERE employee_id = l_actual_employee_id
420: AND organization_id = p_organization_id
421: AND effective_date = (
422: SELECT MAX(effective_date)

Line 423: FROM wip_employee_labor_rates

419: WHERE employee_id = l_actual_employee_id
420: AND organization_id = p_organization_id
421: AND effective_date = (
422: SELECT MAX(effective_date)
423: FROM wip_employee_labor_rates
424: WHERE employee_id = l_actual_employee_id
425: AND organization_id = p_organization_id
426: AND effective_date <= sysdate
427: );