APPS.PO_REQCHANGEREQUESTWF_PVT dependencies on FND_USER

Line 407: l_approver_user_name fnd_user.user_name%TYPE;

403: l_numerator_rate number;
404: l_approval_currency varchar2(30);
405: l_amount_disp varchar2(60);
406: l_amount_approval_currency number;
407: l_approver_user_name fnd_user.user_name%TYPE;
408: l_user_id fnd_user.user_id%TYPE;
409: l_progress varchar2(200);
410: l_no_rate_msg varchar2(200);
411:

Line 408: l_user_id fnd_user.user_id%TYPE;

404: l_approval_currency varchar2(30);
405: l_amount_disp varchar2(60);
406: l_amount_approval_currency number;
407: l_approver_user_name fnd_user.user_name%TYPE;
408: l_user_id fnd_user.user_id%TYPE;
409: l_progress varchar2(200);
410: l_no_rate_msg varchar2(200);
411:
412: begin

Line 428: FROM fnd_user

424: aname=>'APPROVER_USER_NAME');
425: if (l_approver_user_name is not null) then
426: SELECT user_id
427: INTO l_user_id
428: FROM fnd_user
429: WHERE user_name = l_approver_user_name;
430:
431: l_progress := 'getReqAmountInfo:' || l_user_id;
432: IF (g_po_wf_debug = 'Y') THEN