91:
92: BEGIN
93: SELECT HR.EMPLOYEE_ID
94: INTO x_employee_id
95: FROM FND_USER FND, HR_EMPLOYEES_CURRENT_V HR
96: WHERE FND.USER_ID = x_user_id
97: AND FND.EMPLOYEE_ID = HR.EMPLOYEE_ID
98: AND ROWNUM = 1;
99: EXCEPTION
92: BEGIN
93: SELECT HR.EMPLOYEE_ID
94: INTO x_employee_id
95: FROM FND_USER FND, HR_EMPLOYEES_CURRENT_V HR
96: WHERE FND.USER_ID = x_user_id
97: AND FND.EMPLOYEE_ID = HR.EMPLOYEE_ID
98: AND ROWNUM = 1;
99: EXCEPTION
100: WHEN others THEN