APPS.OKL_SUBSIDY_POOL_APPROVAL_PVT SQL Statements

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

Line: 27

    SELECT decision_status_code
          ,pool_type_code
          ,subsidy_pool_name
          ,effective_from_date
          ,effective_to_date
          ,id
      FROM okl_subsidy_pools_b
     WHERE id = p_subsidy_pool_id;

Line: 38

    SELECT count(*) number_of_lines
      FROM okl_subsidy_pool_budgets_b
     WHERE subsidy_pool_id = p_subsidy_pool_id;

Line: 44

    SELECT id
          ,budget_type_code
          ,decision_status_code
          ,budget_amount
      FROM okl_subsidy_pool_budgets_b
     WHERE subsidy_pool_id = p_subsidy_pool_id;

Line: 53

    SELECT 'X'
      FROM okl_subsidies_b
     WHERE subsidy_pool_id = p_subsidy_pool_id;

Line: 276

      okl_subsidy_pool_pvt.update_total_budget(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 => p_subsidy_pool_id
                                              ,p_total_budget_amt => cv_get_pool_line_details_csr.budget_amount);

Line: 287

                                'okl_subsidy_pool_pvt.update_total_budget returned with status '||x_return_status||' x_msg_data '||x_msg_data
                                );

Line: 366

    SELECT pool.subsidy_pool_name
          ,pool.decision_status_code pool_status
          ,pool.effective_from_date pool_start_date
          ,pool.effective_to_date pool_end_date
          ,pool.total_budgets
          ,pool.id pool_id
          ,line.budget_amount
          ,line.budget_type_code
          ,line.decision_status_code line_status
          ,line.id budget_line_id
      FROM okl_subsidy_pools_b pool
          ,okl_subsidy_pool_budgets_b line
     WHERE pool.id = line.subsidy_pool_id
       AND line.id = p_subsidy_pool_budget_id;

Line: 512

        okl_subsidy_pool_pvt.update_total_budget(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_get_pool_info.pool_id
                                                ,p_total_budget_amt => lv_calc_total_budget);

Line: 523

                                  'okl_subsidy_pool_pvt.update_total_budget with lv_calc_total_budget '||lv_calc_total_budget||' returned with '||x_return_status||
                                  ' x_msg_data '||x_msg_data
                                  );

Line: 568

        okl_subsidy_pool_pvt.update_total_budget(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_get_pool_info.pool_id
                                                ,p_total_budget_amt => lv_calc_total_budget);

Line: 579

                                  'okl_subsidy_pool_pvt.update_total_budget with lv_calc_total_budget '||lv_calc_total_budget||' status '||x_return_status||
                                  ' x_msg_data '||x_msg_data
                                  );