APPS.AMS_SCHEDULERULES_PVT dependencies on AMS_JTF_RS_EMP_V

Line 1232: FROM ams_jtf_rs_emp_v

1228: )
1229: IS
1230: CURSOR c_resource IS
1231: SELECT resource_id
1232: FROM ams_jtf_rs_emp_v
1233: WHERE user_id = FND_GLOBAL.user_id ;
1234:
1235: CURSOR c_schedule IS
1236: SELECT *

Line 2650: FROM ams_jtf_rs_emp_v

2646: l_user_id NUMBER;
2647:
2648: CURSOR c_user IS
2649: SELECT user_id
2650: FROM ams_jtf_rs_emp_v
2651: WHERE resource_id = p_resource_id;
2652: BEGIN
2653: OPEN c_user;
2654: FETCH c_user INTO l_user_id;

Line 3463: FROM ams_jtf_rs_emp_v

3459: l_schedule_rec c_schedule_det%ROWTYPE;
3460:
3461: CURSOR c_emp_dtl(l_res_id IN NUMBER) IS
3462: SELECT employee_id
3463: FROM ams_jtf_rs_emp_v
3464: WHERE resource_id = l_res_id ;
3465: l_emp_id NUMBER;
3466: l_user_name VARCHAR2(100);
3467: l_display_name VARCHAR2(100);

Line 5066: FROM ams_jtf_rs_emp_v

5062: and parentCSCH.schedule_id = nvl(csch.orig_Csch_id,csch.schedule_id);
5063:
5064: CURSOR c_emp_dtl(l_res_id IN NUMBER) IS
5065: SELECT employee_id
5066: FROM ams_jtf_rs_emp_v
5067: WHERE resource_id = l_res_id ;
5068:
5069: l_schedule_id NUMBER;
5070: l_schedule_name VARCHAR2(240);