APPS.JTF_TASK_UTL dependencies on FND_USER

Line 816: FROM fnd_user

812: IS
813: CURSOR c_assigned_by_id
814: IS
815: SELECT user_id assigned_by_id
816: FROM fnd_user
817: WHERE user_id = p_assigned_by_id
818: AND NVL (end_date, SYSDATE) >= SYSDATE
819: AND NVL (start_date, SYSDATE) <= SYSDATE;
820:

Line 824: FROM fnd_user

820:
821: CURSOR c_assigned_by_name
822: IS
823: SELECT user_id assigned_by_id
824: FROM fnd_user
825: WHERE user_name = p_assigned_by_name
826: AND NVL (end_date, SYSDATE) >= SYSDATE
827: AND NVL (start_date, SYSDATE) <= SYSDATE;
828: BEGIN

Line 3041: l_user_name fnd_user.user_name%TYPE;

3037: -----------------------------
3038: FUNCTION get_user_name (p_user_id IN NUMBER)
3039: RETURN VARCHAR2
3040: IS
3041: l_user_name fnd_user.user_name%TYPE;
3042: BEGIN
3043: IF p_user_id IS NULL
3044: THEN
3045: RETURN NULL;

Line 3049: FROM fnd_user

3045: RETURN NULL;
3046: ELSE
3047: SELECT user_name
3048: INTO l_user_name
3049: FROM fnd_user
3050: WHERE user_id = p_user_id;
3051: RETURN l_user_name;
3052: END IF;
3053: END;