APPS.OKC_XPRT_QA_PVT dependencies on OKC_ARTICLE_VERSIONS

Line 648: FROM okc_article_versions v,

644: ) ;
645:
646: CURSOR l_check_art_effectivity(p_article_id IN NUMBER) IS
647: SELECT v.article_status
648: FROM okc_article_versions v,
649: okc_articles_all a
650: WHERE a.article_id = v.article_id
651: AND a.article_id = p_article_id
652: AND v.article_status IN ('APPROVED','ON_HOLD')

Line 657: FROM okc_article_versions v,

653: AND sysdate BETWEEN v.start_date AND NVL(v.end_date,sysdate+1);
654:
655: CURSOR csr_approved_ver_exists(p_article_id IN NUMBER) IS
656: SELECT 'x'
657: FROM okc_article_versions v,
658: okc_articles_all a
659: WHERE a.article_id = v.article_id
660: AND a.article_id = p_article_id
661: AND v.article_status IN ('APPROVED','ON_HOLD');

Line 872: FROM okc_article_versions v,

868: ) ;
869:
870: CURSOR l_check_art_effectivity(p_article_id IN NUMBER) IS
871: SELECT 'x'
872: FROM okc_article_versions v,
873: okc_articles_all a
874: WHERE a.article_id = v.article_id
875: AND a.article_id = p_article_id
876: AND v.article_status IN ('DRAFT','PENDING_APPROVAL','REJECTED')

Line 881: FROM okc_article_versions v,

877: -- AND sysdate BETWEEN v.start_date AND NVL(v.end_date,sysdate+1)
878: AND NOT EXISTS
879: (
880: SELECT 'x'
881: FROM okc_article_versions v,
882: okc_articles_all a
883: WHERE a.article_id = v.article_id
884: AND a.article_id = p_article_id
885: AND v.article_status IN ('APPROVED','ON_HOLD')