APPS.OKC_XPRT_QA_PVT dependencies on OKC_ARTICLE_VERSIONS

Line 686: FROM okc_article_versions v,

682: ) ;
683:
684: CURSOR l_check_art_effectivity(p_article_id IN NUMBER) IS
685: SELECT v.article_status
686: FROM okc_article_versions v,
687: okc_articles_all a
688: WHERE a.article_id = v.article_id
689: AND a.article_id = p_article_id
690: AND v.article_status IN ('APPROVED','ON_HOLD')

Line 695: FROM okc_article_versions v,

691: AND sysdate BETWEEN v.start_date AND NVL(v.end_date,sysdate+1);
692:
693: CURSOR csr_approved_ver_exists(p_article_id IN NUMBER) IS
694: SELECT 'x'
695: FROM okc_article_versions v,
696: okc_articles_all a
697: WHERE a.article_id = v.article_id
698: AND a.article_id = p_article_id
699: AND v.article_status IN ('APPROVED','ON_HOLD');

Line 931: FROM okc_article_versions v,

927: ) ;
928:
929: CURSOR l_check_art_effectivity(p_article_id IN NUMBER) IS
930: SELECT 'x'
931: FROM okc_article_versions v,
932: okc_articles_all a
933: WHERE a.article_id = v.article_id
934: AND a.article_id = p_article_id
935: AND v.article_status IN ('DRAFT','PENDING_APPROVAL','REJECTED')

Line 940: FROM okc_article_versions v,

936: -- AND sysdate BETWEEN v.start_date AND NVL(v.end_date,sysdate+1)
937: AND NOT EXISTS
938: (
939: SELECT 'x'
940: FROM okc_article_versions v,
941: okc_articles_all a
942: WHERE a.article_id = v.article_id
943: AND a.article_id = p_article_id
944: AND v.article_status IN ('APPROVED','ON_HOLD')