APPS.OKL_REV_LOSS_PROV_PVT SQL Statements

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

Line: 38

  SELECT id, date_transaction_occurred, transaction_date
  FROM OKL_TRX_CONTRACTS
  WHERE khr_id = p_khr_id
  AND tsu_code = 'PROCESSED'
  AND tcn_type = p_tcn_type
  AND representation_type = G_PRIMARY;

Line: 47

  SELECT txl.id, txl.amount, txl.currency_code
  FROM OKL_TXL_CNTRCT_LNS txl, OKL_TRX_CONTRACTS trx
  WHERE trx.khr_id = p_khr_id
  AND txl.tcn_id = trx.id
  AND txl.tcn_id = p_tcn_id --trx.id
  AND trx.tsu_code = 'PROCESSED'
  AND trx.tcn_type = p_tcn_type
  AND trx.representation_type = G_PRIMARY;

Line: 58

  SELECT id, date_transaction_occurred, transaction_date
  FROM OKL_TRX_CONTRACTS
  WHERE khr_id = p_khr_id
  AND tsu_code = 'PROCESSED'
  AND (tcn_type = 'PSP' OR tcn_type = 'PGL')
  AND representation_type = G_PRIMARY;

Line: 67

  SELECT txl.id, txl.amount, txl.currency_code
  FROM OKL_TXL_CNTRCT_LNS txl, OKL_TRX_CONTRACTS trx
  WHERE trx.khr_id = p_khr_id
  AND txl.tcn_id = trx.id
  AND txl.tcn_id = p_tcn_id --trx.id
  AND trx.tsu_code = 'PROCESSED'
  AND (trx.tcn_type = 'PSP' OR trx.tcn_type = 'PGL')
  AND trx.representation_type = G_PRIMARY;

Line: 78

  SELECT  id
  FROM OKC_K_HEADERS_ALL_B
  WHERE CONTRACT_NUMBER = p_ctr_num;

Line: 232

       Okl_Trx_Contracts_Pub.update_trx_contracts
                         (p_api_version => p_api_version,
                          p_init_msg_list => p_init_msg_list,
                          x_return_status => l_return_status,
                          x_msg_count => x_msg_count,
                          x_msg_data => x_msg_data,
                          p_tcnv_tbl => l_tcnv_tbl,
                          x_tcnv_tbl => x_tcnv_tbl);