DBA Data[Home] [Help]

APPS.OKC_XPRT_RULE_PVT dependencies on OKC_ARTICLES_ALL

Line 279: FROM okc_articles_all

275: -- Get the validation from ArticlesSearchExpVO.xml
276: CURSOR c_validate_clause
277: IS
278: SELECT 'Y'
279: FROM okc_articles_all
280: WHERE org_id = g_org_id
281: AND standard_yn = 'Y'
282: AND article_id = p_article_id
283: AND article_intent = p_intent;

Line 288: FROM okc_articles_all art,

284:
285: CURSOR cur_val_adopted_article
286: IS
287: SELECT 'Y'
288: FROM okc_articles_all art,
289: okc_article_versions ver,
290: okc_article_adoptions adp
291: WHERE art.article_id = ver.article_id
292: AND art.standard_yn = 'Y'