APPS.OKL_STREAMS_WF SQL Statements

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

Line: 44

  SELECT
    ORP_CODE, KHR_ID
  FROM okl_stream_interfaces
  WHERE okl_stream_interfaces.transaction_number = p_trx_number;

Line: 53

  SELECT chr.orig_system_source_code,
         chr.start_date,
         chr.end_date,
         chr.template_yn,
         chr.authoring_org_id,
         chr.inv_organization_id,
         khr.deal_type,
         pdt.id  pid,
         NVL(pdt.reporting_pdt_id, -1) report_pdt_id,
         chr.currency_code currency_code,
         khr.term_duration term
  FROM okc_k_headers_v chr,
       okl_k_headers khr,
       okl_products_v pdt
  WHERE khr.id = chr.id
  AND chr.id = chrId
  AND khr.pdt_id = pdt.id(+);

Line: 199

            OKL_POPULATE_PRCENG_RESULT_PUB.UPDATE_STATUS(--p_api_version => l_api_version,
	                                                     --p_init_msg_list => l_init_msg_list,
	                                                     p_transaction_number => l_transaction_number,
                                                         p_sis_code => G_SIS_CODE,
														 p_srt_code =>  G_SRT_CODE,
														 p_log_file_name => 'OKLSTXMLG_' || l_transaction_number || '.log',
                                                         x_return_status => l_return_status
														 );