DBA Data[Home] [Help]

APPS.AMS_APPROVAL_PVT dependencies on FND_USER

Line 419: -- fnd_user and jtf_resource_extns

415:
416: /*============================================================================*/
417: -- Given the resource Name it returns the full name of the user
418: -- Ams_jtf_rs_emp_v is a view created for AMS based on
419: -- fnd_user and jtf_resource_extns
420: /*============================================================================*/
421: PROCEDURE Get_User_Name
422: ( p_user_id IN NUMBER,
423: x_full_name OUT NOCOPY VARCHAR2,

Line 476: FROM fnd_user f, ams_jtf_rs_emp_v r

472: l_territory VARCHAR2(30);
473:
474: CURSOR c_res_details(p_user_name IN VARCHAR2) IS
475: SELECT r.resource_id
476: FROM fnd_user f, ams_jtf_rs_emp_v r
477: WHERE r.user_id = f.user_id
478: AND f.user_name = p_user_name;
479:
480: BEGIN