APPS.AMS_LIST_IMPORT_PUB dependencies on AMS_USER_STATUSES_VL

Line 3461: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

3457: );
3458: end if;
3459: l_lookup_code := 'ERROR';
3460: l_user_status_id := null;
3461: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
3462: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
3463: system_status_code = 'ERROR' and default_flag = 'Y';
3464:
3465: UPDATE ams_imp_list_headers_all