APPS.OKC_XPRT_UTIL_PVT dependencies on OKC_ARTICLES_ALL

Line 4645: FROM okc_articles_all art,

4641: and rownum < 2;
4642:
4643: CURSOR l_approved_ver_csr(p_article_id NUMBER, effective_date DATE) IS
4644: SELECT ver.article_id, ver.article_version_id, 'L'
4645: FROM okc_articles_all art,
4646: okc_article_versions ver
4647: WHERE art.article_id = p_article_id
4648: AND art.article_id = ver.article_id
4649: AND ver.article_status IN ('APPROVED','ON_HOLD')

Line 5102: FROM okc_articles_all

5098:
5099: RETURN VARCHAR2 IS
5100: CURSOR c1 IS
5101: SELECT article_title
5102: FROM okc_articles_all
5103: WHERE article_id=to_number(p_object_value_code);
5104:
5105: CURSOR C2 IS
5106: SELECT question_name

Line 7830: l_article_number OKC_ARTICLES_ALL.article_number%TYPE;

7826: l_def_scn_code okc_article_versions.default_section%TYPE;
7827: l_scn_code okc_sections_b.scn_code%TYPE;
7828:
7829:
7830: l_article_number OKC_ARTICLES_ALL.article_number%TYPE;
7831:
7832: --Bug#4757731 cursor to get clause title and clause description
7833: CURSOR csr_clause_details(b_article_id NUMBER, b_article_version_id NUMBER) IS
7834: SELECT article_title,article_description, a.article_number

Line 7835: FROM okc_articles_all a,okc_article_versions ver

7831:
7832: --Bug#4757731 cursor to get clause title and clause description
7833: CURSOR csr_clause_details(b_article_id NUMBER, b_article_version_id NUMBER) IS
7834: SELECT article_title,article_description, a.article_number
7835: FROM okc_articles_all a,okc_article_versions ver
7836: WHERE a.article_id = b_article_id
7837: AND a.article_id = ver.article_id
7838: AND ver.article_version_id = b_article_version_id;
7839: