687: p_user_id NUMBER
688: )
689: IS
690: SELECT hr.employee_id
691: FROM fnd_user fnd, per_employees_current_x hr
692: WHERE fnd.user_id = p_user_id
693: AND fnd.employee_id = hr.employee_id
694: AND ROWNUM = 1;
695:
688: )
689: IS
690: SELECT hr.employee_id
691: FROM fnd_user fnd, per_employees_current_x hr
692: WHERE fnd.user_id = p_user_id
693: AND fnd.employee_id = hr.employee_id
694: AND ROWNUM = 1;
695:
696: l_emp_id NUMBER;