715:
716: return l_result;
717: END;
718:
719: FUNCTION get_fnd_user_name (
720: p_user_id IN NUMBER )
721: return VARCHAR2 IS
722:
723: CURSOR c_user_name IS
721: return VARCHAR2 IS
722:
723: CURSOR c_user_name IS
724: SELECT user_name
725: FROM fnd_user
726: WHERE user_id = p_user_id
727: AND sysdate between start_date and nvl(end_date,SYSDATE);
728:
729: l_user_name fnd_user.user_name%type;
725: FROM fnd_user
726: WHERE user_id = p_user_id
727: AND sysdate between start_date and nvl(end_date,SYSDATE);
728:
729: l_user_name fnd_user.user_name%type;
730: BEGIN
731:
732: OPEN c_user_name;
733: