DBA Data[Home] [Help]

APPS.AMS_LISTIMPORT_PVT dependencies on FND_USER

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

Line 928: where fnd.user_Name = upper(x_sa_email_address)

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
932: select status_code from ams_imp_list_headers_all

Line 929: and fnd.user_id = ams.user_id;

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
932: select status_code from ams_imp_list_headers_all
933: where import_list_header_id = p_import_list_header_id;