DBA Data[Home] [Help]

APPS.INV_PHY_INV_LOVS dependencies on FND_USER

Line 825: FROM mtl_employees_current_view mec, fnd_user fus

821: --Bug 6600166, raising error if user is not a valid employee
822: BEGIN
823: SELECT fus.employee_id
824: INTO l_employee_id
825: FROM mtl_employees_current_view mec, fnd_user fus
826: WHERE fus.user_id = p_user_id
827: AND mec.employee_id = fus.employee_id
828: AND mec.organization_id = p_organization_id;
829: EXCEPTION

Line 1007: FROM mtl_employees_current_view mec, fnd_user fus

1003: --Bug 6600166, raising error if user is not a valid employee
1004: BEGIN
1005: SELECT fus.employee_id
1006: INTO l_employee_id
1007: FROM mtl_employees_current_view mec, fnd_user fus
1008: WHERE fus.user_id = p_user_id
1009: AND mec.employee_id = fus.employee_id
1010: AND mec.organization_id = p_organization_id;
1011: EXCEPTION