APPS.MSC_X_PURGE_SUPDEM_HISTORY_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 79

                /* create the basic delete sql for Deletes in batches of 100K */
	        lv_sql_stmt := ' DELETE /*+ PARALLEL(msdh) */ '
		             ||' MSC_SUP_DEM_HISTORY msdh '
			     ||' WHERE plan_id = -1 '
			     ||' AND ROWNUM < 100001 ';

Line: 128

	       LOG_MESSAGE('Number of records deleted in SQL#1 :  ' || SQL%ROWCOUNT);

Line: 145

		   LOG_MESSAGE('Number of records deleted in SQL#2 :  ' || SQL%ROWCOUNT);