APPS.OKL_SLA_PROCESSING_PVT SQL Statements

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

Line: 40

 SELECT event_id, source_id_int_1
   FROM xla_post_acctg_events_v
  WHERE application_id = p_application_id;

Line: 67

    UPDATE okl_trx_contracts_all
       SET tsu_code = 'CANCELED',
	       canceled_date = sysdate,
		   accounting_reversal_yn = 'N'
     WHERE id = l_tcn_tbl(i)
	   AND exists( SELECT 1
	                 FROM okl_trns_acc_dstrs_all
				    WHERE accounting_event_id = l_event_tbl(i)
					  AND gl_reversal_flag = 'Y' );