APPS.OKC_K_ARTICLE_PUB dependencies on OKC_BUS_DOC_TYPES_B

Line 811: SELECT intent FROM OKC_BUS_DOC_TYPES_B

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;
813: BEGIN
814: IF (l_debug = 'Y') THEN
815: okc_debug.log('11400: Entering Process_Non_Std_Article', 2);