APPS.OKL_AM_ARINV_PVT SQL Statements

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

Line: 56

      SELECT  approved_yn,
              acs_code,
              part_name,
              actual_repair_cost -- SECHAWLA  6797795 Added
      FROM    OKL_ASSET_CNDTN_LNS_V
      WHERE   id = p_acn_id;

Line: 230

      SELECT id,
             acd_id
      FROM   OKL_ASSET_CNDTN_LNS_V
      WHERE  id = p_acn_id;

Line: 355

    OKL_ASSET_CNDTN_LNS_PUB.update_asset_cndtn_lns(
          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_acnv_tbl       => lp_acnv_tbl,
          x_acnv_tbl       => lx_acnv_tbl);