APPS.OKL_SEC_AGREMNT_BOOK_PVT SQL Statements

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

Line: 49

    select khr.deal_type
    from okc_K_headers_v chr,
         okl_K_headers khr
    where chr.id = khr.id
        and chr.id = chrId;

Line: 120

        OKL_SEC_AGREEMENT_PVT.update_sec_agreement_sts(
                                       l_api_version,
                                       p_init_msg_list,
                                       x_return_status,
                                       x_msg_count,
                                       x_msg_data,
                                       l_PassStatus,
                                       p_chr_id );

Line: 129

        OKL_SEC_AGREEMENT_PVT.update_sec_agreement_sts(
                                       l_api_version,
                                       p_init_msg_list,
                                       x_return_status,
                                       x_msg_count,
                                       x_msg_data,
                                       l_FailStatus,
                                       p_chr_id );