APPS.OKC_K_NON_STD_ART_GRP dependencies on OKC_ARTICLE_VERSIONS

Line 94: FROM OKC_ARTICLE_VERSIONS ver, okc_articles_all art

90:
91: -- Fix for bug# 5158268. Modified the cursor to query okc_articles_all for article_number
92: Cursor l_get_std_article IS
93: SELECT ver.article_id,ver.article_version_id, art.article_number
94: FROM OKC_ARTICLE_VERSIONS ver, okc_articles_all art
95: WHERE ver.ARTICLE_VERSION_ID=p_std_article_version_id
96: and art.article_id = ver.article_id;
97:
98:

Line 454: l_display_name okc_article_versions.display_name%TYPE;

450: object_version_number
451: FROM OKC_K_ARTICLES_B
452: WHERE id=p_cat_id;
453:
454: l_display_name okc_article_versions.display_name%TYPE;
455: l_article_description okc_article_versions.article_description%TYPE;
456:
457:
458: BEGIN

Line 455: l_article_description okc_article_versions.article_description%TYPE;

451: FROM OKC_K_ARTICLES_B
452: WHERE id=p_cat_id;
453:
454: l_display_name okc_article_versions.display_name%TYPE;
455: l_article_description okc_article_versions.article_description%TYPE;
456:
457:
458: BEGIN
459: /*IF (l_debug = 'Y') THEN