APPS.AMS_LISTGENERATION_PKG dependencies on AMS_USER_STATUSES_VL

Line 11589: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

11585: l_end_rownum := l_end_rownum + 10000;
11586: END LOOP;
11587: */
11588: Ams_Utility_Pvt.Write_Conc_log('End migrate_lists : '||to_char(p_list_header_id));
11589: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
11590: WHERE system_status_type = 'AMS_LIST_STATUS' AND
11591: system_status_code = 'AVAILABLE' and default_flag = 'Y';
11592: UPDATE ams_list_headers_all
11593: set status_code = 'AVAILABLE',