DBA Data[Home] [Help]

APPS.AMS_APPROVAL_PVT dependencies on FND_USER

Line 454: -- fnd_user and jtf_resource_extns

450:
451: /*============================================================================*/
452: -- Given the resource Name it returns the full name of the user
453: -- Ams_jtf_rs_emp_v is a view created for AMS based on
454: -- fnd_user and jtf_resource_extns
455: /*============================================================================*/
456: PROCEDURE Get_User_Name
457: ( p_user_id IN NUMBER,
458: x_full_name OUT NOCOPY VARCHAR2,

Line 511: FROM fnd_user f, ams_jtf_rs_emp_v r

507: l_territory VARCHAR2(30);
508:
509: CURSOR c_res_details(p_user_name IN VARCHAR2) IS
510: SELECT r.resource_id
511: FROM fnd_user f, ams_jtf_rs_emp_v r
512: WHERE r.user_id = f.user_id
513: AND f.user_name = p_user_name;
514:
515: BEGIN