APPS.OKC_IMP_TERMS_TEMPLATES_PVT dependencies on OKC_ARTICLES_ALL

Line 626: FROM okc_articles_all

622:
623: CURSOR cur_val_article
624: IS
625: SELECT 'Y'
626: FROM okc_articles_all
627: WHERE 1 = 1
628: AND standard_yn = 'Y'
629: AND org_id = p_org_id
630: AND article_intent = p_intent

Line 636: FROM okc_articles_all art,

632:
633: CURSOR cur_val_adopted_article
634: IS
635: SELECT 'Y'
636: FROM okc_articles_all art,
637: okc_article_versions ver,
638: okc_article_adoptions adp
639: WHERE art.article_id = ver.article_id
640: AND art.standard_yn = 'Y'