APPS.OKL_AM_SYSTEM_PARAMS_PVT SQL Statements

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

Line: 51

     SELECT 'x'
     FROM fa_book_controls
     where book_class =  'TAX'
     AND   distribution_source_book = cp_asst_add_book_type_code
     AND   book_type_code = cp_tax_book;

Line: 58

     SELECT BOOK_TYPE_NAME
     FROM fa_book_controls
     where book_class =  'CORPORATE'
     AND   book_type_code = cp_asst_add_book_type_code;

Line: 64

     SELECT BOOK_TYPE_NAME
     FROM fa_book_controls
     where book_type_code = cp_tax_book_code;

Line: 73

   select secondary_rep_method, rpt_prod_book_type_code
   from   okl_system_params p, okl_sys_acct_opts a
   where  p.org_id = a.org_id;

Line: 442

          OKL_SYSTEM_PARAMS_ALL_PUB.insert_system_parameters(
                    p_api_version    => p_api_version,
                    p_init_msg_list  => G_FALSE,
                    x_return_status  => l_return_status,
                    x_msg_count      => x_msg_count,
                    x_msg_data       => x_msg_data,
                    p_sypv_rec       => p_sypv_rec,
                    x_sypv_rec       => x_sypv_rec);

Line: 460

          OKL_SYSTEM_PARAMS_ALL_PUB.update_system_parameters(
                    p_api_version    => p_api_version,
                    p_init_msg_list  => G_FALSE,
                    x_return_status  => l_return_status,
                    x_msg_count      => x_msg_count,
                    x_msg_data       => x_msg_data,
                    p_sypv_rec       => p_sypv_rec,
                    x_sypv_rec       => x_sypv_rec);