[Home] [Help]
1058: -- select employee information
1059: begin
1060: SELECT nvl(first_name ||' '||last_name,p_user_name)
1061: INTO l_employee_name
1062: FROM PER_PEOPLE_F
1063: WHERE PERSON_ID=
1064: (select employee_id from fnd_user where user_name=p_user_name);
1065: exception
1066: when others then