DBA Data[Home] [Help]

APPS.INV_VALIDATE dependencies on MTL_EMPLOYEES_CURRENT_VIEW

Line 359: FROM mtl_employees_current_view

355:
356: IF p_employee_id IS NOT NULL THEN
357: SELECT last_name,full_name
358: INTO p_last_name,p_full_name
359: FROM mtl_employees_current_view
360: WHERE employee_id = p_employee_id
361: AND organization_id = p_org.organization_id;
362: ELSE
363: BEGIN

Line 366: FROM mtl_employees_current_view

362: ELSE
363: BEGIN
364: SELECT employee_id,last_name,full_name
365: INTO p_employee_id,p_last_name,p_full_name
366: FROM mtl_employees_current_view
367: WHERE organization_id = p_org.organization_id
368: -- Bug 4951746, following where clause voided the index use
369: -- therefore cauased performance issue
370: -- changed to avoid the NVL and DECODE