APPS.OKC_K_NON_STD_ART_GRP dependencies on OKC_ARTICLE_VERSIONS

Line 91: FROM OKC_ARTICLE_VERSIONS ver, okc_articles_all art

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

Line 445: l_display_name okc_article_versions.display_name%TYPE;

441: object_version_number
442: FROM OKC_K_ARTICLES_B
443: WHERE id=p_cat_id;
444:
445: l_display_name okc_article_versions.display_name%TYPE;
446: l_article_description okc_article_versions.article_description%TYPE;
447:
448:
449: BEGIN

Line 446: l_article_description okc_article_versions.article_description%TYPE;

442: FROM OKC_K_ARTICLES_B
443: WHERE id=p_cat_id;
444:
445: l_display_name okc_article_versions.display_name%TYPE;
446: l_article_description okc_article_versions.article_description%TYPE;
447:
448:
449: BEGIN
450: /*IF (l_debug = 'Y') THEN