DBA Data[Home] [Help]

APPS.AMS_LIST_PURGE_PVT dependencies on AMS_USER_STATUSES_B

Line 110: FROM ams_user_statuses_b

106: WHERE import_list_header_id = p_imp_header_id;
107:
108: CURSOR c_get_usr_status (p_lookup_code VARCHAR2) IS
109: SELECT user_status_id
110: FROM ams_user_statuses_b
111: WHERE system_status_code = p_lookup_code
112: AND system_status_type = 'AMS_IMPORT_STATUS';
113:
114: l_current_usage NUMBER := null;