APPS.OKL_LPO_STRM_PVT SQL Statements

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

Line: 22

		   /*SELECT distinct id
		   FROM okl_strm_type_b
		   WHERE BILLABLE_YN = 'Y';*/

Line: 25

		   SELECT sty_id
		   FROM okl_strm_tmpt_all_types_uv sty
		   WHERE sty.BILLABLE_YN = 'Y'
           and not exists (select 1 from OKL_STRM_TYPE_EXEMPT_V sem
                           where sem.lpo_id = p_lpo_id
                           and   sem.sty_id = sty.sty_id);

Line: 41

        okl_strm_type_exempt_pub.insert_strm_type_exempt(
                           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_slxv_rec	   => l_slx_rec
                          ,x_slxv_rec	   => p_slx_rec
                          );