APPS.OKL_DEAL_PAYMENTS_PVT SQL Statements

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

Line: 45

    SELECT styt.name
    FROM okl_strm_type_tl styt,
         okc_k_items cim_fee
    WHERE cim_fee.cle_id = p_cle_id
    AND   cim_fee.dnz_chr_id = p_chr_id
    AND   cim_fee.jtot_object1_code = 'OKL_STRMTYP'
    AND   styt.id = cim_fee.object1_id1
    AND   styt.language = USERENV('LANG');

Line: 56

    SELECT msit.description
    FROM   mtl_system_items_tl msit,
           okc_k_items cim_svc
    WHERE cim_svc.cle_id = p_cle_id
    AND   cim_svc.dnz_chr_id = p_chr_id
    AND   cim_svc.jtot_object1_code = 'OKX_SERVICE'
    AND   msit.inventory_item_id = cim_svc.object1_id1
    AND   msit.organization_id = cim_svc.object1_id2
    AND   msit.language = USERENV('LANG');

Line: 116

    SELECT clet_fin.name
    FROM okc_k_lines_tl clet_fin
    WHERE clet_fin.id = p_cle_id
    AND   clet_fin.language = USERENV('LANG');

Line: 123

    SELECT clet_fin.name
    FROM okc_k_lines_tl clet_fin,
         okc_k_items    cim_cov_asset
    WHERE cim_cov_asset.cle_id = p_cle_id
    AND   cim_cov_asset.dnz_chr_id = p_chr_id
    AND   cim_cov_asset.jtot_object1_code = 'OKX_COVASST'
    AND   clet_fin.id = cim_cov_asset.object1_id1
    AND   clet_fin.language = USERENV('LANG');

Line: 171

    SELECT lse_id,
           cle_id
    FROM okc_k_lines_b cle
    WHERE id = p_cle_id;

Line: 179

    SELECT clet_fin.id,
           clet_fin.name,
           clet_fin.item_description
    FROM okc_k_lines_tl clet_fin
    WHERE clet_fin.id = p_cle_id
    AND   clet_fin.language = USERENV('LANG');

Line: 188

    SELECT clet_fin.id,
           clet_fin.name,
           clet_fin.item_description
    FROM okc_k_lines_tl clet_fin,
         okc_k_items    cim_cov_asset
    WHERE cim_cov_asset.cle_id = p_cle_id
    AND   cim_cov_asset.dnz_chr_id = p_chr_id
    AND   cim_cov_asset.jtot_object1_code = 'OKX_COVASST'
    AND   clet_fin.id = cim_cov_asset.object1_id1
    AND   clet_fin.language = USERENV('LANG');