[Home] [Help]
20: FUNCTION GENP_GET_WHO_NAME(p_last_updated_by IN NUMBER)
21: RETURN VARCHAR2 IS
22: CURSOR c_user_name is
23: SELECT user_name
24: FROM fnd_user
25: WHERE user_id=p_last_updated_by;
26: x_user_name VARCHAR2(100);
27: begin
28: OPEN c_user_name;