APPS.OKC_K_ARTICLE_PUB dependencies on OKC_ARTICLE_VERSIONS
Line 769: FROM okc_article_versions
765: RETURN NUMBER IS
766: l_art_ver_id NUMBER;
767: CURSOR get_art_ver_id_crs IS
768: SELECT article_version_id 769: FROM okc_article_versions 770: WHERE article_id=p_art_id
771: AND (nvl(sav_release, To_Char(article_version_number))=p_ver_num
772: OR p_ver_num IS NULL AND SYSDATE BETWEEN Start_date AND nvl(end_date,sysdate)
773: )