APPS.OKC_TERMS_MULTIREC_GRP dependencies on OKC_ARTICLE_VERSIONS

Line 1003: FROM OKC_ARTICLE_VERSIONS VERS

999: SELECT vers.article_id article_id,
1000: vers.article_version_id article_version_id,
1001: nvl(vers.default_section,'UNASSIGNED') scn_code,
1002: nvl(PROVISION_YN,'N') provision_yn
1003: FROM OKC_ARTICLE_VERSIONS VERS
1004: WHERE vers.article_id = b_article_id
1005: AND article_status in ('ON_HOLD','APPROVED')
1006: AND b_article_effective_date >= vers.start_date
1007: AND b_article_effective_date <= nvl(vers.end_date,b_article_effective_date+1);

Line 1014: FROM OKC_ARTICLE_VERSIONS VERS

1010: SELECT article_id,
1011: article_version_id,
1012: nvl(vers.default_section,'UNASSIGNED') scn_code,
1013: nvl(PROVISION_YN,'N') provision_yn
1014: FROM OKC_ARTICLE_VERSIONS VERS
1015: WHERE article_id= b_article_id
1016: AND article_status in ('ON_HOLD','APPROVED')
1017: AND start_date = (select max(start_date) FROM OKC_ARTICLE_VERSIONS
1018: WHERE article_id= b_article_id

Line 1017: AND start_date = (select max(start_date) FROM OKC_ARTICLE_VERSIONS

1013: nvl(PROVISION_YN,'N') provision_yn
1014: FROM OKC_ARTICLE_VERSIONS VERS
1015: WHERE article_id= b_article_id
1016: AND article_status in ('ON_HOLD','APPROVED')
1017: AND start_date = (select max(start_date) FROM OKC_ARTICLE_VERSIONS
1018: WHERE article_id= b_article_id
1019: AND article_status in ('ON_HOLD','APPROVED') );
1020:
1021: CURSOR l_get_scn_csr(b_scn_code VARCHAR2) IS

Line 1100: FROM OKC_ARTICLE_VERSIONS VERS,

1096: SELECT VERS.ARTICLE_ID article_id,
1097: ADP.GLOBAL_ARTICLE_VERSION_ID article_version_id,
1098: NVL(VERS.default_section,'UNASSIGNED') scn_code,
1099: NVL(VERS.PROVISION_YN,'N') provision_yn
1100: FROM OKC_ARTICLE_VERSIONS VERS,
1101: OKC_ARTICLE_ADOPTIONS ADP
1102: WHERE ADP.GLOBAL_ARTICLE_VERSION_ID = VERS.ARTICLE_VERSION_ID
1103: AND VERS.ARTICLE_ID = b_article_id
1104: AND nvl(b_article_effective_date,sysdate) >= VERS.START_DATE

Line 1117: FROM OKC_ARTICLE_VERSIONS VERS,

1113: SELECT VERS.ARTICLE_ID article_id,
1114: ADP.GLOBAL_ARTICLE_VERSION_ID article_version_id,
1115: NVL(VERS.default_section,'UNASSIGNED') scn_code,
1116: NVL(VERS.PROVISION_YN,'N') provision_yn
1117: FROM OKC_ARTICLE_VERSIONS VERS,
1118: OKC_ARTICLE_ADOPTIONS ADP
1119: WHERE ADP.GLOBAL_ARTICLE_VERSION_ID = VERS.ARTICLE_VERSION_ID
1120: AND VERS.ARTICLE_ID = b_article_id
1121: AND VERS.ARTICLE_STATUS IN ('ON_HOLD','APPROVED')

Line 1882: SELECT article_id , 'x' FROM OKC_ARTICLE_VERSIONS

1878:
1879: l_article_id NUMBER;
1880:
1881: CURSOR l_check_version(b_article_version_id NUMBER) IS
1882: SELECT article_id , 'x' FROM OKC_ARTICLE_VERSIONS
1883: WHERE article_version_id=b_article_version_id;
1884:
1885: BEGIN
1886:

Line 2785: FROM okc_article_versions av, okc_review_upld_terms ar, okc_k_articles_b akb

2781: CURSOR article_properties(b_review_upld_terms_id NUMBER) is
2782: SELECT av.insert_by_reference,
2783: akb.mandatory_yn,
2784: av.lock_text
2785: FROM okc_article_versions av, okc_review_upld_terms ar, okc_k_articles_b akb
2786: WHERE av.article_version_id = ar.article_version_id
2787: AND akb.id = ar.object_id
2788: AND ar.review_upld_terms_id = b_review_upld_terms_id;
2789: