APPS.OKL_AM_SV_WRITEDOWN_PVT SQL Statements

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

Line: 65

   SELECT to_number(l.asset_id) , l.asset_number, l.item_description, l.salvage_value, l.original_cost, l.current_units,
          l.corporate_book, l.dnz_chr_id, h.contract_number
   FROM   okx_asset_lines_v l, okc_k_headers_b h
   WHERE  l.dnz_chr_id = h.id
   AND    l.parent_line_id = p_cle_id;

Line: 75

   SELECT l.asset_number
   FROM   OKL_TRX_ASSETS h, okl_txl_assets_v l
   WHERE  h.id = l.tas_id
   AND    h.tsu_code = 'ENTERED'
   AND    h.tas_type = 'FSC'
   AND    l.kle_id = p_kle_id;

Line: 84

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

Line: 94

   SELECT  legal_entity_id
   FROM    okl_k_headers
   WHERE   id = cp_khr_id;

Line: 121

      SELECT SYSDATE INTO l_sysdate FROM dual;