APPS.AMS_EVTREGS_PVT dependencies on AMS_JTF_RS_EMP_V

Line 59: FROM ams_jtf_rs_emp_v

55: l_user_id NUMBER;
56:
57: CURSOR c_user IS
58: SELECT user_id
59: FROM ams_jtf_rs_emp_v
60: WHERE resource_id = p_resource_id;
61: BEGIN
62: OPEN c_user;
63: FETCH c_user INTO l_user_id;

Line 5253: FROM ams_jtf_rs_emp_v

5249: FROM dual;
5250:
5251: CURSOR c_user(p_resource_id IN NUMBER) IS
5252: SELECT user_id
5253: FROM ams_jtf_rs_emp_v
5254: WHERE resource_id = p_resource_id;
5255:
5256: l_interaction_rec JTF_IH_PUB.interaction_rec_type;
5257: l_activities JTF_IH_PUB.activity_tbl_type;