APPS.POS_WCAPPROVE_PVT dependencies on FND_USER

Line 432: from fnd_user

428:
429:
430: select employee_id
431: into l_employee_id
432: from fnd_user
433: where user_id = l_wc_preparer_id;
434:
435: IF (g_asn_debug = 'Y') THEN
436: debug_log(FND_LOG.LEVEL_STATEMENT,

Line 1254: FROM fnd_user

1250:
1251: elsif (l_next_approver(1).orig_system = 'FND') then --}{
1252: SELECT employee_id
1253: into l_next_approver_id
1254: FROM fnd_user
1255: WHERE user_id = l_next_approver(1).orig_system_id
1256: and trunc(sysdate) between start_date and nvl(end_date, sysdate+1);
1257: end if; --}
1258:

Line 2871: FROM FND_USER FND, HR_EMPLOYEES_CURRENT_V HR

2867: END IF;
2868:
2869: SELECT HR.EMPLOYEE_ID
2870: INTO l_employee_id
2871: FROM FND_USER FND, HR_EMPLOYEES_CURRENT_V HR
2872: WHERE FND.USER_ID = NVL(p_user_id, fnd_global.user_id)
2873: AND FND.EMPLOYEE_ID = HR.EMPLOYEE_ID;
2874: IF (g_asn_debug = 'Y') THEN
2875: debug_log(FND_LOG.LEVEL_STATEMENT,

Line 2872: WHERE FND.USER_ID = NVL(p_user_id, fnd_global.user_id)

2868:
2869: SELECT HR.EMPLOYEE_ID
2870: INTO l_employee_id
2871: FROM FND_USER FND, HR_EMPLOYEES_CURRENT_V HR
2872: WHERE FND.USER_ID = NVL(p_user_id, fnd_global.user_id)
2873: AND FND.EMPLOYEE_ID = HR.EMPLOYEE_ID;
2874: IF (g_asn_debug = 'Y') THEN
2875: debug_log(FND_LOG.LEVEL_STATEMENT,
2876: l_api_name,'l_employee_id '

Line 3112: l_responder_id fnd_user.user_id%TYPE;

3108:
3109:
3110: -- Bug 8479430 - START
3111: -- Declare following context setting variables.
3112: l_responder_id fnd_user.user_id%TYPE;
3113: l_session_user_id NUMBER;
3114: l_session_resp_id NUMBER;
3115: l_session_appl_id NUMBER;
3116: l_preparer_resp_id NUMBER;

Line 3274: FROM fnd_user fu,

3270:
3271:
3272: SELECT fu.USER_ID
3273: INTO l_responder_id
3274: FROM fnd_user fu,
3275: wf_notifications wfn
3276: WHERE wfn.notification_id = l_notification_id
3277: AND wfn.original_recipient = fu.user_name;
3278: