APPS.OKC_K_ARTICLE_PVT dependencies on OKC_K_ARTICLES_B

Line 47: from OKC_K_ARTICLES_B CAT,

43: x_out_rec OKC_CVM_PVT.cvmv_rec_type;
44: --V
45: cursor l_std_art_exists_csr is
46: select STA.NAME
47: from OKC_K_ARTICLES_B CAT,
48: OKC_STD_ARTICLES_V STA
49: where CAT.chr_id = p_catv_rec.chr_id
50: and CAT.sav_sae_id = p_catv_rec.sav_sae_id
51: and STA.ID = CAT.sav_sae_id

Line 142: from OKC_K_ARTICLES_B

138: l_cvmv_rec OKC_CVM_PVT.cvmv_rec_type;
139: x_out_rec OKC_CVM_PVT.cvmv_rec_type;
140: cursor dnz_csr is
141: select dnz_chr_id
142: from OKC_K_ARTICLES_B
143: where id = p_catv_rec.id;
144: --V
145: begin
146: if (l_catv_rec.CAT_TYPE = 'STA') then

Line 202: from OKC_K_ARTICLES_B

198:
199:
200: cursor l_cat_csr is
201: select '!'
202: from OKC_K_ARTICLES_B
203: where cat_id = p_catv_rec.id;
204: CURSOR l_atn_csr IS
205: SELECT '!'
206: FROM Okc_Article_Trans_V

Line 213: from OKC_K_ARTICLES_B

209: l_cvmv_rec OKC_CVM_PVT.cvmv_rec_type;
210: x_out_rec OKC_CVM_PVT.cvmv_rec_type;
211: cursor dnz_csr is
212: select dnz_chr_id
213: from OKC_K_ARTICLES_B
214: where id = p_catv_rec.id;
215: --V
216:
217: cursor section_csr is