APPS.OKC_TERMS_DEVIATIONS_PVT dependencies on OKC_ARTICLE_VERSIONS

Line 126: And Exists (Select 1 From okc_article_versions oav

122: From
123: okc_k_articles_b oab
124: Where document_Type = 'TEMPLATE'
125: And document_Id = p_template_id
126: And Exists (Select 1 From okc_article_versions oav
127: Where oab.sav_sae_id = oav.article_id
128: And oav.provision_yn = 'N');
129:
130: end if; -- l_provision_allowed

Line 468: okc_article_versions

464: END IF;
465:
466: Update okc_terms_deviations_t odt set
467: lock_text_mod_flag = (select lock_text from
468: okc_article_versions
469: where article_version_id = odt.ref_article_version_id)
470: where sequence_id = p_sequence_id
471: and deviation_code = 'MODIFIED_STD';
472:

Line 970: AND EXISTS (Select 1 from okc_article_versions oav

966: FROM okc_k_articles_b oab
967: WHERE document_id = p_doc_id
968: AND document_type = p_doc_type
969: AND nvl(summary_amend_operation_code,'NULL') <> 'DELETED'
970: AND EXISTS (Select 1 from okc_article_versions oav
971: Where oav.article_id = oab.sav_sae_id
972: And oav.article_version_id = oab.article_version_id
973: And trunc(nvl(end_date, sysdate)) < trunc(sysdate));
974: l_compare_flag := 'N';

Line 1019: AND EXISTS (Select 1 from okc_article_versions oav

1015: FROM okc_k_articles_b oab
1016: WHERE document_id = p_doc_id
1017: AND document_type = p_doc_type
1018: and nvl(summary_amend_operation_code,'NULL') <> 'DELETED'
1019: AND EXISTS (Select 1 from okc_article_versions oav
1020: Where oav.article_id = oab.sav_sae_id
1021: And oav.article_version_id = oab.article_version_id
1022: And oav.article_status = 'ON_HOLD')
1023: AND NOT EXISTS (Select 1 from okc_terms_deviations_t odt