APPS.AMS_GEN_APPROVAL_PVT dependencies on FND_USER

Line 146: FROM fnd_user f, ams_jtf_rs_emp_v r

142: l_territory VARCHAR2(30);
143:
144: CURSOR c_res_details(p_user_name IN VARCHAR2) IS
145: SELECT r.resource_id
146: FROM fnd_user f, ams_jtf_rs_emp_v r
147: WHERE r.user_id = f.user_id
148: AND f.user_name = p_user_name;
149:
150: BEGIN