APPS.OE_APPROVALS_WF dependencies on FND_USER

Line 2954: l_preparer_user_name fnd_user.user_name%TYPE;

2950: l_orig_system VARCHAR2 (3);
2951: l_orig_system_id NUMBER;
2952: l_first_approver_id NUMBER;
2953: l_first_position_id NUMBER;
2954: l_preparer_user_name fnd_user.user_name%TYPE;
2955: l_doc_string VARCHAR2 (200);
2956: l_ame_exception ame_util.longeststringtype;
2957: l_approver_response VARCHAR2 (20);
2958: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 3170: -- FND User Record.

3166: l_person_id := -1;
3167: END;
3168: ELSIF (l_orig_system = ame_util.fnduserorigsystem)
3169: THEN
3170: -- FND User Record.
3171: SELECT employee_id
3172: INTO l_person_id
3173: FROM fnd_user
3174: WHERE user_id = l_orig_system_id

Line 3173: FROM fnd_user

3169: THEN
3170: -- FND User Record.
3171: SELECT employee_id
3172: INTO l_person_id
3173: FROM fnd_user
3174: WHERE user_id = l_orig_system_id
3175: AND TRUNC (SYSDATE) BETWEEN start_date
3176: AND NVL (end_date, SYSDATE + 1);
3177: END IF;