APPS.AMS_ACTPRODUCT_PVT dependencies on AMS_JTF_RS_EMP_V

Line 119: FROM ams_jtf_rs_emp_v

115: l_res_id NUMBER;
116:
117: CURSOR get_res_id(l_user_id IN NUMBER) IS
118: SELECT resource_id
119: FROM ams_jtf_rs_emp_v
120: WHERE user_id = l_user_id;
121:
122: CURSOR C_act_product_id IS
123: SELECT ams_act_products_s.NEXTVAL

Line 405: FROM ams_jtf_rs_emp_v

401: l_res_id NUMBER;
402:
403: CURSOR get_res_id(l_user_id IN NUMBER) IS
404: SELECT resource_id
405: FROM ams_jtf_rs_emp_v
406: WHERE user_id = l_user_id;
407:
408: BEGIN
409: -- Standard Start of API savepoint

Line 632: FROM ams_jtf_rs_emp_v

628: AND ACT_PRODUCT_USED_BY_ID = c_obj_id;
629:
630: CURSOR get_res_id(l_user_id IN NUMBER) IS
631: SELECT resource_id
632: FROM ams_jtf_rs_emp_v
633: WHERE user_id = l_user_id;
634:
635: CURSOR get_obj_info(l_actprd_id IN NUMBER) IS
636: SELECT arc_act_product_used_by, act_product_used_by_id