APPS.OKC_TERMS_VERSION_PVT dependencies on OKC_ARTICLES_ALL

Line 54: FROM okc_k_articles_b kart,okc_articles_all art

50:
51: CURSOR cat_crs IS
52: SELECT kart.id, kart.object_version_number,kart.amendment_operation_code,kart.summary_amend_operation_code,
53: DECODE(art.standard_yn,'N','Y',NULL) change_nonstd_yn
54: FROM okc_k_articles_b kart,okc_articles_all art
55: WHERE kart.document_type = p_doc_type AND kart.document_id = p_doc_id
56: AND kart.sav_sae_id = art.article_id
57: AND (kart.amendment_operation_code IS NOT NULL OR kart.amendment_description IS NOT NULL
58: OR kart.summary_amend_operation_code IS NOT NULL OR art.standard_yn='N');

Line 75: FROM okc_k_articles_b kart,okc_articles_all

71: AND SUMMARY_AMEND_OPERATION_CODE IS NULL;
72:
73: CURSOR cat_incremental_crs IS
74: SELECT id, kart.object_version_number, amendment_operation_code,standard_yn
75: FROM okc_k_articles_b kart,okc_articles_all
76: WHERE document_type = p_doc_type AND document_id = p_doc_id
77: AND sav_sae_id = article_id
78: AND (amendment_operation_code IS NOT NULL
79: OR standard_yn='N');

Line 495: FROM okc_k_articles_b kart,okc_articles_all

491: AND SUMMARY_AMEND_OPERATION_CODE IS NULL;
492:
493: CURSOR cat_crs IS
494: SELECT id, kart.object_version_number, amendment_operation_code,standard_yn
495: FROM okc_k_articles_b kart,okc_articles_all
496: WHERE document_type = p_doc_type AND document_id = p_doc_id
497: AND sav_sae_id = article_id
498: AND (amendment_operation_code IS NOT NULL
499: OR standard_yn='N');