APPS.OKC_TERMS_MULTIREC_GRP dependencies on OKC_ARTICLES_ALL

Line 1101: FROM OKC_ARTICLES_ALL

1097: l_current_org_id VARCHAR2(100);
1098:
1099: CURSOR l_get_article_org_csr(b_article_id NUMBER) IS
1100: SELECT org_id
1101: FROM OKC_ARTICLES_ALL
1102: WHERE article_id = b_article_id;
1103:
1104: CURSOR l_get_local_article_csr(b_article_id IN NUMBER,
1105: b_local_org_id IN NUMBER,

Line 1143: FROM okc_k_articles_b,okc_articles_all

1139: l_max_local_article_rec l_get_max_local_article_csr%ROWTYPE;
1140:
1141: CURSOR get_articles_order_art_num is
1142: SELECT id,scn_id
1143: FROM okc_k_articles_b,okc_articles_all
1144: WHERE document_type=p_doc_type AND
1145: document_id=p_doc_id AND
1146: sav_sae_id=article_id
1147: ORDER BY scn_id,article_number;