APPS.AMS_LISTGENERATION_PKG dependencies on AMS_USER_STATUSES_VL

Line 11690: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

11686: l_end_rownum := l_end_rownum + 10000;
11687: END LOOP;
11688: */
11689: Ams_Utility_Pvt.Write_Conc_log('End migrate_lists : '||to_char(p_list_header_id));
11690: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
11691: WHERE system_status_type = 'AMS_LIST_STATUS' AND
11692: system_status_code = 'AVAILABLE' and default_flag = 'Y';
11693: UPDATE ams_list_headers_all
11694: set status_code = 'AVAILABLE',