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