5535: BEGIN
5536:
5537: SELECT HR.employee_id
5538: INTO l_employee_id
5539: FROM FND_USER FND,
5540: HR_EMPLOYEES_CURRENT_V HR
5541: WHERE FND.user_id = p_user_id
5542: AND FND.employee_id = HR.employee_id ;
5543:
5537: SELECT HR.employee_id
5538: INTO l_employee_id
5539: FROM FND_USER FND,
5540: HR_EMPLOYEES_CURRENT_V HR
5541: WHERE FND.user_id = p_user_id
5542: AND FND.employee_id = HR.employee_id ;
5543:
5544: EXCEPTION
5545: WHEN No_Data_Found THEN