APPS.AMS_LISTIMPORT_PVT dependencies on AMS_JTF_RS_EMP_V

Line 927: select ams.resource_id from ams_jtf_rs_emp_v ams , fnd_user fnd

923: and lookup_code = x_vehicle_code and enabled_flag = 'Y';
924:
925:
926: CURSOR resource_exists (x_sa_email_address varchar) IS
927: select ams.resource_id from ams_jtf_rs_emp_v ams , fnd_user fnd
928: where fnd.user_Name = upper(x_sa_email_address)
929: and fnd.user_id = ams.user_id;
930:
931: cursor c_hdr_status is