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