APPS.OKC_K_ARTICLE_PUB dependencies on OKC_TERMS_ARTICLES_V

Line 805: FROM okc_terms_articles_v t, okc_articles_all a

801: l_intent VARCHAR2(1);
802: l_txt CLOB;
803: CURSOR art_id_crs (p_id NUMBER) IS
804: SELECT t.sav_sae_id, t.article_version_id, a.standard_yn
805: FROM okc_terms_articles_v t, okc_articles_all a
806: WHERE t.id=p_id AND t.sav_sae_id=a.article_id;
807: CURSOR l_get_intent_csr(p_doc_type VARCHAR2) IS
808: SELECT intent FROM OKC_BUS_DOC_TYPES_B
809: WHERE DOCUMENT_TYPE=p_doc_type;