APPS.AMS_APPROVAL_PVT dependencies on AMS_JTF_RS_EMP_V

Line 268: FROM ams_jtf_rs_emp_v

264: l_error_msg VARCHAR2(4000);
265:
266: CURSOR c_resource IS
267: SELECT user_id user_id, resource_name
268: FROM ams_jtf_rs_emp_v
269: WHERE resource_id = p_user ;
270:
271: BEGIN
272: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

Line 375: FROM ams_jtf_rs_emp_v

371: l_error_msg VARCHAR2(4000);
372:
373: CURSOR c_resource IS
374: SELECT user_id user_id
375: FROM ams_jtf_rs_emp_v
376: WHERE resource_id = p_user ;
377:
378: BEGIN
379: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

Line 453: -- Ams_jtf_rs_emp_v is a view created for AMS based on

449:
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,

Line 467: FROM ams_jtf_rs_emp_v

463: l_error_msg VARCHAR2(4000);
464:
465: CURSOR c_resource IS
466: SELECT full_name
467: FROM ams_jtf_rs_emp_v
468: WHERE resource_id = p_user_id ;
469: BEGIN
470: /*AMS_Utility_PVT.create_log(x_return_status => l_return_stat,
471: p_arc_log_used_by => 'AMS Markeing Approval',

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

Line 623: FROM ams_jtf_rs_emp_v

619:
620:
621: CURSOR c_resource IS
622: SELECT employee_id , user_id, category
623: FROM ams_jtf_rs_emp_v
624: WHERE resource_id = p_user_id ;
625:
626: l_person_id NUMBER;
627: l_user_id NUMBER;

Line 1702: FROM ams_jtf_rs_emp_v

1698: -- [END OF BUG2741039 FIXING]
1699:
1700: CURSOR c_resource IS
1701: SELECT resource_id ,employee_id source_id,full_name resource_name
1702: FROM ams_jtf_rs_emp_v
1703: WHERE user_id = x_resource_id ;
1704: BEGIN
1705: Fnd_Msg_Pub.initialize();
1706:

Line 7211: FROM ams_jtf_rs_emp_v

7207: resultout OUT NOCOPY VARCHAR2)
7208: IS
7209: CURSOR res_user_csr (p_resource_id IN NUMBER) IS
7210: SELECT user_id
7211: FROM ams_jtf_rs_emp_v
7212: WHERE resource_id = p_resource_id ;
7213:
7214: l_auto_amount NUMBER;
7215: l_approver_id NUMBER;