APPS.OKL_PURGE_STRM_INTF_PVT SQL Statements

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

Line: 55

  DELETE FROM OKL_SIF_FEES
  WHERE sif_id IN (SELECT id FROM okl_stream_interfaces
                   WHERE creation_date < l_end_date
                   AND sis_code NOT IN ('DATA_ENTERED', 'HDR_INSERTED',
                           'PROCESSING_REQUEST', 'RET_DATA_RECEIVED'));

Line: 63

  DELETE FROM OKL_SIF_LINES
  WHERE sif_id IN (SELECT id FROM okl_stream_interfaces
                   WHERE creation_date < l_end_date
                   AND sis_code NOT IN ('DATA_ENTERED', 'HDR_INSERTED',
                           'PROCESSING_REQUEST', 'RET_DATA_RECEIVED'));

Line: 73

  DELETE FROM OKL_SIF_STREAM_TYPES
  WHERE sif_id IN (SELECT id FROM okl_stream_interfaces
                   WHERE creation_date < l_end_date
                   AND sis_code NOT IN ('DATA_ENTERED', 'HDR_INSERTED',
                           'PROCESSING_REQUEST', 'RET_DATA_RECEIVED'));

Line: 82

  DELETE FROM OKL_SIF_YIELDS
  WHERE sif_id IN (SELECT id FROM okl_stream_interfaces
                   WHERE creation_date < l_end_date
                   AND sis_code NOT IN ('DATA_ENTERED', 'HDR_INSERTED',
                           'PROCESSING_REQUEST', 'RET_DATA_RECEIVED'));

Line: 91

  DELETE FROM OKL_SIF_PRICING_PARAMS
  WHERE sif_id IN (SELECT id FROM okl_stream_interfaces
                   WHERE creation_date < l_end_date
                   AND sis_code NOT IN ('DATA_ENTERED', 'HDR_INSERTED',
                           'PROCESSING_REQUEST', 'RET_DATA_RECEIVED'));

Line: 100

  DELETE FROM OKL_SIF_TRX_PARMS
  WHERE sif_id IN (SELECT id FROM okl_stream_interfaces
                   WHERE creation_date < l_end_date
                   AND sis_code NOT IN ('DATA_ENTERED', 'HDR_INSERTED',
                           'PROCESSING_REQUEST', 'RET_DATA_RECEIVED'));

Line: 110

  DELETE FROM OKL_SIF_RET_LEVELS
  WHERE sir_id IN (SELECT rets.id from OKL_SIF_RETS rets, okl_stream_interfaces str
            WHERE  rets.transaction_number = str.transaction_number
             and str.creation_date < l_end_date
                                    AND str.sis_code NOT IN ('DATA_ENTERED', 'HDR_INSERTED',
                                   'PROCESSING_REQUEST', 'RET_DATA_RECEIVED'));

Line: 120

  DELETE FROM OKL_SIF_RET_ERRORS
  WHERE sir_id IN (SELECT rets.id from OKL_SIF_RETS rets, okl_stream_interfaces str
            WHERE  rets.transaction_number = str.transaction_number
             and str.creation_date < l_end_date
                                    AND str.sis_code NOT IN ('DATA_ENTERED', 'HDR_INSERTED',
                                   'PROCESSING_REQUEST', 'RET_DATA_RECEIVED'));

Line: 131

  DELETE FROM OKL_SIF_RET_STRMS
  WHERE sir_id IN (SELECT rets.id from OKL_SIF_RETS rets, okl_stream_interfaces str
            WHERE  rets.transaction_number = str.transaction_number
             and str.creation_date < l_end_date
                                    AND str.sis_code NOT IN ('DATA_ENTERED', 'HDR_INSERTED',
                                   'PROCESSING_REQUEST', 'RET_DATA_RECEIVED'));

Line: 142

  DELETE FROM okl_stream_trx_data
  WHERE transaction_number IN (SELECT transaction_number FROM okl_stream_interfaces
                   WHERE creation_date < l_end_date
                   AND sis_code NOT IN ('DATA_ENTERED', 'HDR_INSERTED',
                           'PROCESSING_REQUEST', 'RET_DATA_RECEIVED'));

Line: 153

  DELETE FROM OKL_SIF_RETS
  WHERE transaction_number IN (SELECT transaction_number FROM okl_stream_interfaces
                   WHERE creation_date < l_end_date
                   AND sis_code NOT IN ('DATA_ENTERED', 'HDR_INSERTED',
                           'PROCESSING_REQUEST', 'RET_DATA_RECEIVED'));

Line: 162

  DELETE FROM OKL_STREAM_INTERFACES
  WHERE creation_date < l_end_date
  AND sis_code NOT IN ('DATA_ENTERED', 'HDR_INSERTED',
  'PROCESSING_REQUEST', 'RET_DATA_RECEIVED');