APPS.AMS_UTILITY_PVT dependencies on AMS_JTF_RS_EMP_V

Line 1342: FROM ams_jtf_rs_emp_v

1338: l_resource_name VARCHAR2(240);
1339:
1340: CURSOR c_resource_name IS
1341: SELECT full_name
1342: FROM ams_jtf_rs_emp_v
1343: WHERE resource_id = p_resource_id;
1344: BEGIN
1345: IF p_resource_id IS NULL THEN
1346: RETURN NULL;

Line 1569: FROM ams_jtf_rs_emp_v

1565: l_resource_id NUMBER;
1566:
1567: CURSOR c_resource IS
1568: SELECT resource_id
1569: FROM ams_jtf_rs_emp_v
1570: WHERE user_id = p_user_id;
1571: BEGIN
1572: OPEN c_resource;
1573: FETCH c_resource INTO l_resource_id;

Line 2391: FROM ams_jtf_rs_emp_v

2387: l_error_msg VARCHAR2(4000);
2388:
2389: CURSOR c_resource IS
2390: SELECT employee_id , user_id, category
2391: FROM ams_jtf_rs_emp_v
2392: WHERE resource_id = p_resource_id ;
2393:
2394: l_person_id number;
2395: l_user_id number;

Line 2743: FROM ams_jtf_rs_emp_v

2739: l_user_id NUMBER;
2740:
2741: CURSOR c_user IS
2742: SELECT user_id
2743: FROM ams_jtf_rs_emp_v
2744: WHERE resource_id = p_resource_id;
2745: BEGIN
2746: OPEN c_user;
2747: FETCH c_user INTO l_user_id;