APPS.AMS_APPROVAL_PVT dependencies on AMS_JTF_RS_EMP_V

Line 233: FROM ams_jtf_rs_emp_v

229: l_error_msg VARCHAR2(4000);
230:
231: CURSOR c_resource IS
232: SELECT user_id user_id, resource_name
233: FROM ams_jtf_rs_emp_v
234: WHERE resource_id = p_user ;
235:
236: BEGIN
237: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

Line 340: FROM ams_jtf_rs_emp_v

336: l_error_msg VARCHAR2(4000);
337:
338: CURSOR c_resource IS
339: SELECT user_id user_id
340: FROM ams_jtf_rs_emp_v
341: WHERE resource_id = p_user ;
342:
343: BEGIN
344: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

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

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

Line 432: FROM ams_jtf_rs_emp_v

428: l_error_msg VARCHAR2(4000);
429:
430: CURSOR c_resource IS
431: SELECT full_name
432: FROM ams_jtf_rs_emp_v
433: WHERE resource_id = p_user_id ;
434: BEGIN
435: /*AMS_Utility_PVT.create_log(x_return_status => l_return_stat,
436: p_arc_log_used_by => 'AMS Markeing Approval',

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

Line 588: FROM ams_jtf_rs_emp_v

584:
585:
586: CURSOR c_resource IS
587: SELECT employee_id , user_id, category
588: FROM ams_jtf_rs_emp_v
589: WHERE resource_id = p_user_id ;
590:
591: l_person_id NUMBER;
592: l_user_id NUMBER;

Line 1666: FROM ams_jtf_rs_emp_v

1662: -- [END OF BUG2741039 FIXING]
1663:
1664: CURSOR c_resource IS
1665: SELECT resource_id ,employee_id source_id,full_name resource_name
1666: FROM ams_jtf_rs_emp_v
1667: WHERE user_id = x_resource_id ;
1668: BEGIN
1669: Fnd_Msg_Pub.initialize();
1670:

Line 7120: FROM ams_jtf_rs_emp_v

7116: resultout OUT NOCOPY VARCHAR2)
7117: IS
7118: CURSOR res_user_csr (p_resource_id IN NUMBER) IS
7119: SELECT user_id
7120: FROM ams_jtf_rs_emp_v
7121: WHERE resource_id = p_resource_id ;
7122:
7123: l_auto_amount NUMBER;
7124: l_approver_id NUMBER;