APPS.OE_HOLDS_PVT dependencies on FND_USER

Line 229: from fnd_user

225: WHERE TASK_ID = p_hold_entity_id;
226:
227: CURSOR user_value_cur IS
228: select user_name
229: from fnd_user
230: WHERE user_id = p_hold_entity_id;
231:
232: --ER#7479609 end
233:

Line 411: p_user_id IN FND_USER.USER_ID%TYPE )

407: END hold_name;
408:
409: ------------------
410: function user_name (
411: p_user_id IN FND_USER.USER_ID%TYPE )
412: return VARCHAR2
413: IS
414: l_user_name VARCHAR2(100) := '';
415: BEGIN

Line 418: from fnd_user

414: l_user_name VARCHAR2(100) := '';
415: BEGIN
416: select USER_NAME
417: into l_user_name
418: from fnd_user
419: where USER_ID = p_user_id;
420: return l_user_name;
421: END user_name;
422: -----------------

Line 2601: FROM fnd_user

2597: --ER#7479609 start
2598: ELSIF p_hold_source_rec.hold_entity_code2 = 'CB' THEN
2599: SELECT 'Valid Entity'
2600: INTO l_dummy
2601: FROM fnd_user
2602: WHERE user_id = p_hold_source_rec.hold_entity_id2;
2603: ELSIF p_hold_source_rec.hold_entity_code2 = 'D' THEN
2604: SELECT 'Valid Entity'
2605: INTO l_dummy