DBA Data[Home] [Help]

APPS.OKC_CREATE_PO_FROM_K_PVT dependencies on FND_USER

Line 428: l_k_buyer_name fnd_user.user_name%TYPE;

424:
425: l_notif_flag VARCHAR2(1):=OKC_API.g_false;
426: l_send_notif VARCHAR2(1):=OKC_API.g_false;
427: l_notification_string VARCHAR2(4000);
428: l_k_buyer_name fnd_user.user_name%TYPE;
429:
430:
431:
432: BEGIN

Line 448: FROM FND_USER

444: -- Call the workflow notification alert */
445:
446: SELECT user_name
447: INTO l_k_buyer_name
448: FROM FND_USER
449: WHERE EMPLOYEE_ID = (SELECT cco.object1_id1 agent_id
450: FROM okc_contacts cco
451: WHERE cco.cro_code = 'BUYER'
452: AND cco.jtot_object1_code = 'OKX_BUYER'