APPS.OKL_CASH_RULES_SUMRY_PVT SQL Statements

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

Line: 47

           SELECT B.cau_id, A.NAME, B.DEFAULT_RULE
           FROM   OKL_CSH_ALLCTN_RL_HDR A, OKL_CASH_ALLCTN_RLS B
           WHERE  A.ID = B.CAU_ID
           AND    B.ID = p_cat_id;

Line: 53

           SELECT ID
           FROM   OKL_CASH_ALLCTN_RLS
           WHERE  cau_ID = p_car_id  AND
                  (end_date >= trunc(sysdate) OR end_date IS NULL)
           ORDER  BY START_DATE DESC;

Line: 120

            Okl_Cash_Allctn_Rls_Pub.update_cash_allctn_rls( p_api_version    => p_api_version
                                                       ,p_init_msg_list  => p_init_msg_list
                                                       ,x_return_status  => l_return_status
                                                       ,x_msg_count      => l_msg_count
                                                       ,x_msg_data       => l_msg_data
                                                       ,p_catv_rec       => l_catv_rec
                                                       ,x_catv_rec       => x_catv_rec
                                                      );

Line: 164

        Okl_Cash_Allctn_Rls_Pub.update_cash_allctn_rls( p_api_version    => p_api_version
                                                       ,p_init_msg_list  => p_init_msg_list
                                                       ,x_return_status  => l_return_status
                                                       ,x_msg_count      => l_msg_count
                                                       ,x_msg_data       => l_msg_data
                                                       ,p_catv_tbl       => l_catv_tbl
                                                       ,x_catv_tbl       => l_catv_tbl
                                                      );