APPS.OKC_K_ARTICLE_PUB dependencies on OKC_SECTIONS_B

Line 600: SELECT ID FROM OKC_SECTIONS_B

596: CURSOR org_id_crs IS
597: SELECT authoring_org_id
598: FROM OKC_K_HEADERS_B WHERE document_id=p_doc_id;
599: CURSOR get_unasgn_scn_id_crs IS
600: SELECT ID FROM OKC_SECTIONS_B
601: WHERE document_type = p_doc_type AND document_id = p_doc_id
602: AND scn_code = G_UNASSIGNED_SECTION_CODE;
603: CURSOR get_doc_usage_crs IS
604: SELECT TEMPLATE_ID FROM okc_template_usages_v