APPS.OKE_CONTRACT_PRINTING_PKG SQL Statements

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

Line: 10

         SELECT MEANING
         FROM FND_LOOKUPS
         WHERE LOOKUP_TYPE ='OKC_SUBJECT'
         AND LOOKUP_CODE = p_sbt_code;

Line: 37

     select 'x'
    FROM OKE_K_LINES_FULL_HV
    WHERE k_line_id= vk_line_id
    AND parent_line_id is NULL
    AND MAJOR_VERSION=vVersion;

Line: 44

    SELECT line_number
    INTO l_linenum
    FROM OKE_K_LINES_FULL_HV
    WHERE k_line_id =vk_line_id
    AND MAJOR_VERSION=vVersion;

Line: 57

       SELECT parent_line_id
       INTO l_parent_id
       FROM OKE_K_LINES_FULL_HV
       WHERE k_line_id=vk_line_id
       AND MAJOR_VERSION=vVersion;

Line: 81

     select 'x'
    FROM OKE_K_LINES_FULL_V
    WHERE k_line_id= vk_line_id
    AND parent_line_id is NULL;

Line: 87

    SELECT line_number
    INTO l_linenum
    FROM OKE_K_LINES_FULL_V
    WHERE k_line_id =vk_line_id;

Line: 99

       SELECT parent_line_id
       INTO l_parent_id
       FROM OKE_K_LINES_FULL_V
       WHERE k_line_id=vk_line_id;

Line: 124

      select org.name
      from hr_all_organization_units org
      ,    okc_k_headers_b ch
      where org.organization_id = ch.inv_organization_id
      and   ch.id =p_id ;

Line: 182

         SELECT NAME,SBT_CODE
         FROM OKC_STD_ARTICLES_V
         WHERE ID = p_id;

Line: 235

        select max(major_version)
        from oke_k_headers_hv
        where k_header_id =p_id;

Line: 240

        select line_number
        from oke_k_lines_hv
        where header_id = p_id
        and k_line_id = p_line_id
        and major_version = p_version;

Line: 247

        select line_number
        from oke_k_lines_v
        where header_id = p_id
        and k_line_id = p_line_id;

Line: 253

        select cle_id,comments,text
        from okc_k_articles_hv
        where dnz_chr_id = p_id
        and cat_type=p_cat_type
        and sav_sae_id=p_sav_sae_id
        and sav_sav_release = p_sav_sav_release
        and major_version = p_version;

Line: 262

        select cle_id,comments,text
        from okc_k_articles_v
        where dnz_chr_id = p_id
        and cat_type=p_cat_type
        and sav_sae_id=p_sav_sae_id
        and sav_sav_release = p_sav_sav_release;

Line: 362

        select max(major_version)
        from oke_k_headers_hv
        where k_header_id =p_id;

Line: 367

        select line_number
        from oke_k_lines_hv
        where header_id = p_id
        and k_line_id = p_line_id
        and major_version = p_version;

Line: 374

        select line_number
        from oke_k_lines_v
        where header_id = p_id
        and k_line_id = p_line_id;