APPS.OKC_CAT_PVT dependencies on OKC_K_ARTICLES_BH

Line 158: FROM OKC_K_ARTICLES_BH B

154: );
155: DELETE FROM OKC_K_ARTICLES_TLH T
156: WHERE NOT EXISTS (
157: SELECT NULL
158: FROM OKC_K_ARTICLES_BH B
159: WHERE B.ID = T.ID
160: AND B.MAJOR_VERSION = T.MAJOR_VERSION
161: );
162:

Line 4530: INSERT INTO okc_k_articles_bh

4526: okc_debug.Set_Indentation('OKC_CAT_PVT');
4527: okc_debug.log('14900: Entered create_version', 2);
4528: END IF;
4529:
4530: INSERT INTO okc_k_articles_bh
4531: (
4532: major_version,
4533: id,
4534: sav_sae_id,

Line 4729: FROM okc_k_articles_bh

4725: last_update_login,
4726: sav_sav_release
4727: FROM okc_k_articles_tlh
4728: WHERE id in (SELECT id
4729: FROM okc_k_articles_bh
4730: WHERE dnz_chr_id = p_chr_id)
4731: AND major_version = p_major_version;
4732:
4733: -----------------------------------------

Line 4803: FROM okc_k_articles_bh

4799: attribute12,
4800: attribute13,
4801: attribute14,
4802: attribute15
4803: FROM okc_k_articles_bh
4804: WHERE dnz_chr_id = p_chr_id
4805: AND major_version = p_major_version;
4806:
4807: IF (l_debug = 'Y') THEN