APPS.OKC_TERMS_DEVIATIONS_PVT dependencies on OKC_ARTICLES_ALL

Line 710: AND EXISTS (SELECT 1 FROM okc_articles_all oka

706: FROM okc_k_articles_b oab
707: WHERE document_type = p_doc_type
708: AND document_id = p_doc_id
709: AND NVL(summary_amend_operation_code,'NULL') <> 'DELETED'
710: AND EXISTS (SELECT 1 FROM okc_articles_all oka
711: WHERE oka.article_id = oab.sav_sae_id
712: AND standard_YN = 'N')
713: AND NOT EXISTS (SELECT 1 from okc_terms_deviations_temp odt
714: WHERE odt.article_id = oab.orig_article_id);

Line 1123: AND EXISTS (Select 1 from okc_articles_all oaa

1119: FROM okc_k_articles_b oab
1120: WHERE document_id = p_doc_id
1121: AND document_type = p_doc_type
1122: AND nvl(summary_amend_operation_code,'NULL') <> 'DELETED'
1123: AND EXISTS (Select 1 from okc_articles_all oaa
1124: Where oaa.article_id = oab.sav_sae_id
1125: And oaa.standard_yn = 'Y')
1126: AND NOT EXISTS (Select 1 from okc_terms_deviations_temp
1127: Where article_id = nvl(oab.orig_article_id,