[Home] [Help]
85:
86: BEGIN
87: SELECT HR.EMPLOYEE_ID
88: INTO x_employee_id
89: FROM FND_USER FND, HR_EMPLOYEES_CURRENT_V HR
90: WHERE FND.USER_ID = x_user_id
91: AND FND.EMPLOYEE_ID = HR.EMPLOYEE_ID
92: AND ROWNUM = 1;
93: EXCEPTION
86: BEGIN
87: SELECT HR.EMPLOYEE_ID
88: INTO x_employee_id
89: FROM FND_USER FND, HR_EMPLOYEES_CURRENT_V HR
90: WHERE FND.USER_ID = x_user_id
91: AND FND.EMPLOYEE_ID = HR.EMPLOYEE_ID
92: AND ROWNUM = 1;
93: EXCEPTION
94: WHEN others THEN