APPS.OKL_AM_LOAD_CAT_BK_PVT SQL Statements

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

Line: 43

   SELECT DISTINCT fac.category_id, fac.book_type_code
   FROM   fa_category_book_defaults fac, fa_book_controls fbc
   WHERE fac.book_type_code = fbc.book_type_code AND fbc.book_class IN ('CORPORATE','TAX')
   AND   fbc.distribution_source_book = NVL(p_book_type_code, fbc.distribution_source_book);

Line: 51

   SELECT 'x'
   FROM   OKL_AMORT_HOLD_SETUPS
   WHERE  category_id = p_id
   AND    book_type_code = p_code;

Line: 96

             okl_amort_hold_setups_pub.insert_amort_hold_setups(
                                    p_api_version                  => 1.0
                                    ,p_init_msg_list                => FND_API.G_FALSE
                                    ,x_return_status                => x_return_status
                                    ,x_msg_count                    => x_msg_count
                                    ,x_msg_data                     => x_msg_data
                                    ,p_amhv_tbl                     => lp_amhv_tbl
                                    ,x_amhv_tbl                     => lx_amhv_tbl);