APPS.OKC_K_ARTICLE_PUB dependencies on OKC_TERMS_ARTICLES_V

Line 808: FROM okc_terms_articles_v t, okc_articles_all a

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