APPS.OKL_CREDIT_MGNT_PVT SQL Statements

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

Line: 43

      SELECT credit_req_number,
             status
      FROM   okl_credit_requests
      WHERE  quote_id = p_contract_id
      AND    status IN ('SUBMITTED' , 'APPROVED');

Line: 50

      SELECT CREDIT_CLASSIFICATION_CODE
      FROM   hz_cust_accounts
      WHERE  cust_account_id = p_chr_rec.cust_acct_id;

Line: 93

    SELECT  chr.start_date,
            chr.currency_code,
            chr.authoring_org_id,
            cpl.object1_id1,
            khr.term_duration
    INTO    l_k_start_date,
            l_currency,
            l_org_id,
            l_party_id,
            l_term
    FROM    okc_k_headers_b chr,
            okl_k_headers khr,
            okc_k_party_roles_b cpl
    WHERE   chr.id = p_contract_id
    AND     chr.id = khr.id
    AND     chr.id = cpl.dnz_chr_id
    AND     cpl.rle_code = 'LESSEE';

Line: 111

    SELECT AR_CMGT_APPLICATION_NUM_S.NEXTVAL
    INTO   l_application_number
    FROM   DUAL;

Line: 178

    okl_credit_request_pub.insert_credit_request(
             p_api_version                  => G_API_VERSION
            ,p_init_msg_list                => OKL_API.G_FALSE
            ,x_return_status                => l_return_status
            ,x_msg_count                    => x_msg_count
            ,x_msg_data                     => x_msg_data
            ,p_crqv_rec                     => l_crqv_rec
            ,x_crqv_rec                     => lx_crqv_rec);

Line: 322

      SELECT credit_req_number,
             status
      FROM   okl_credit_requests
      WHERE  quote_id = p_contract_id
      AND    status IN ('SUBMITTED' , 'APPROVED');

Line: 374

    SELECT  chr.id,
            chr.contract_number,
            chr.cust_acct_id,
            chr.currency_code,
            chr.authoring_org_id,
            cpl.object1_id1,
            khr.term_duration
    INTO    x_chr_rec.contract_id,
            x_chr_rec.contract_number,
            x_chr_rec.cust_acct_id,
            x_chr_rec.currency,
            x_chr_rec.org_id,
            x_chr_rec.party_id,
            x_chr_rec.term
    FROM    okc_k_headers_b chr,
            okl_k_headers khr,
            okc_k_party_roles_b cpl
    WHERE   chr.id = p_contract_id
    AND     chr.id = khr.id
    AND     chr.id = cpl.dnz_chr_id
    AND     cpl.rle_code = 'LESSEE';