APPS.AMS_ASSOCIATIONS_PVT dependencies on AMS_JTF_RS_EMP_V

Line 63: FROM ams_jtf_rs_emp_v

59: l_res_id NUMBER;
60:
61: CURSOR get_res_id(l_user_id IN NUMBER) IS
62: SELECT resource_id
63: FROM ams_jtf_rs_emp_v
64: WHERE user_id = l_user_id;
65:
66: CURSOR c_association_seq IS
67: SELECT ams_object_associations_s.NEXTVAL

Line 470: FROM ams_jtf_rs_emp_v

466: and using_object_type = c_attr;
467:
468: CURSOR get_res_id(l_user_id IN NUMBER) IS
469: SELECT resource_id
470: FROM ams_jtf_rs_emp_v
471: WHERE user_id = l_user_id;
472:
473: CURSOR get_master_info(l_obj_id IN NUMBER) IS
474: SELECT master_object_type, master_object_id

Line 828: FROM ams_jtf_rs_emp_v

824: l_res_id NUMBER;
825:
826: CURSOR get_res_id(l_user_id IN NUMBER) IS
827: SELECT resource_id
828: FROM ams_jtf_rs_emp_v
829: WHERE user_id = l_user_id;
830: BEGIN
831:
832: -------------------- initialize -------------------------