APPS.OKL_SUBSIDY_POOL_TRX_PVT SQL Statements

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

Line: 41

    SELECT pool.id
          , pool.effective_from_date
          , pool.effective_to_date
          , pool.decision_status_code
          , sub.name
          , pool.currency_code
          , pool.currency_conversion_type
          , nvl(pool.total_budgets,0) total_budgets
          , nvl(pool.total_subsidy_amount,0) total_subsidy_amount
          , pool.subsidy_pool_name
      FROM okl_subsidy_pools_b pool,
           okl_subsidies_b sub
     WHERE sub.subsidy_pool_id = pool.id
       AND sub.id = p_sixv_rec.subsidy_id;

Line: 256

      OKL_SIX_PVT.insert_row(p_api_version   => p_api_version
                             ,p_init_msg_list => p_init_msg_list
                             ,x_return_status => x_return_status
                             ,x_msg_count     => x_msg_count
                             ,x_msg_data      => x_msg_data
                             ,p_sixv_rec      => l_sixv_rec
                             ,x_sixv_rec      => x_sixv_rec
                            );

Line: 286

      okl_subsidy_pool_pvt.update_subsidy_amount(p_api_version     => p_api_version
                                                 ,p_init_msg_list   => p_init_msg_list
                                                 ,x_return_status   => x_return_status
                                                 ,x_msg_count       => x_msg_count
                                                 ,x_msg_data        => x_msg_data
                                                 ,p_subsidy_pool_id => cv_pool_details.id
                                                 ,p_total_subsidy_amt => lv_total_subsidy_amt
                                                );

Line: 298

                                'updated total_subsisy_amount '||lv_total_subsidy_amt||' with status '||x_return_status || ' x_msg_data '||x_msg_data
                                );