APPS.OKC_COPY_CONTRACT_PVT dependencies on OKC_K_ARTICLES_B

Line 1695: FROM okc_k_articles_b

1691: l_sav_release VARCHAR2(150);
1692:
1693: CURSOR c_sav_sae_id(p_cat_id IN NUMBER) IS
1694: SELECT sav_sae_id
1695: FROM okc_k_articles_b
1696: WHERE id = p_cat_id;
1697:
1698: CURSOR c_latest_version(p_sae_id IN NUMBER) IS
1699: SELECT sav_release

Line 3671: FROM okc_k_articles_b

3667: WHERE cle_id = p_from_cle_id;
3668:
3669: CURSOR c_catv IS
3670: SELECT id
3671: FROM okc_k_articles_b
3672: WHERE cle_id = p_from_cle_id;
3673:
3674: CURSOR c_pavv IS
3675: SELECT id

Line 6092: FROM okc_k_articles_b

6088: ---------------------------------------------------
6089: /* 11510
6090: CURSOR c_catv IS
6091: SELECT id
6092: FROM okc_k_articles_b
6093: WHERE dnz_chr_id = p_chr_id
6094: AND cle_id is null
6095: AND g_copy_history_yn = 'N'
6096: UNION ALL

Line 6098: FROM okc_k_articles_bH

6094: AND cle_id is null
6095: AND g_copy_history_yn = 'N'
6096: UNION ALL
6097: SELECT id
6098: FROM okc_k_articles_bH
6099: WHERE dnz_chr_id = p_chr_id and cle_id is null
6100: AND major_version = G_FROM_VERSION_NUMBER
6101: AND G_COPY_HISTORY_YN = 'Y';
6102: */