APPS.OKC_COPY_CONTRACT_PVT dependencies on OKC_K_ARTICLES_B

Line 1694: FROM okc_k_articles_b

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

Line 3670: FROM okc_k_articles_b

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

Line 6091: FROM okc_k_articles_b

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

Line 6097: FROM okc_k_articles_bH

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