APPS.AMS_GEN_APPROVAL_PVT dependencies on FND_USER

Line 144: FROM fnd_user f, ams_jtf_rs_emp_v r

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