APPS.AMS_LIST_IMPORT_PUB dependencies on AMS_USER_STATUSES_VL

Line 3468: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

3464: );
3465: end if;
3466: l_lookup_code := 'ERROR';
3467: l_user_status_id := null;
3468: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
3469: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
3470: system_status_code = 'ERROR' and default_flag = 'Y';
3471:
3472: UPDATE ams_imp_list_headers_all