APPS.OKL_AM_RV_WRITEDOWN_PVT SQL Statements

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

Line: 73

   SELECT  l.name, l.item_description, l.residual_value, l.oec, l.chr_id, h.contract_number
   FROM    okl_k_lines_full_v l, okc_k_headers_b h
   WHERE   l.chr_id = h.id
   AND     l.id = p_id;

Line: 83

   SELECT count(*)
   FROM   OKL_TRX_ASSETS h, okl_txl_assets_v l
   WHERE  h.id = l.tas_id
   AND    h.tsu_code IN ('ENTERED', 'ERROR')
   AND    h.tas_type = 'ARC'
   AND    l.dnz_khr_id = p_khr_id;

Line: 92

   SELECT  l.name
   FROM    okl_trx_quotes_b qh, okl_txl_quote_lines_b ql, okl_k_lines_full_v l
   WHERE   qh.id = ql.qte_id
   AND     qh.qst_code = 'ACCEPTED'
   AND     ql.qlt_code = 'AMCFIA'
   AND     ql.kle_id  = l.id
   AND     ql.kle_id = p_kle_id;

Line: 102

   SELECT  legal_entity_id
   FROM    okl_k_headers
   WHERE   id = cp_khr_id;

Line: 111

   SELECT start_date,
          end_date
   FROM okc_k_headers_b
   WHERE id = p_chr_id;

Line: 138

      SELECT SYSDATE INTO l_sysdate FROM dual;