APPS.OKL_CONTRACT_APP_WF SQL Statements

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

Line: 18

    okl_contract_status_pub.update_contract_status(p_api_version   => G_API_VERSION,
                                                   p_init_msg_list => G_FALSE,
                                                   p_khr_status    => p_khr_status,
                                                   p_chr_id        => p_chr_id,
                                                   x_return_status => lx_return_status,
                                                   x_msg_count     => lx_msg_count,
                                                   x_msg_data      => lx_msg_data);

Line: 84

    SELECT okl_wf_item_s.nextval
    FROM  dual;

Line: 106

    l_parameter_list.DELETE;

Line: 142

    SELECT chrv.contract_number
    FROM okc_k_headers_v chrv
    WHERE chrv.id = p_contract_id;