APPS.OKC_K_ARTICLE_PUB dependencies on OKC_K_HEADERS_B

Line 595: FROM OKC_K_HEADERS_B WHERE document_id=p_doc_id;

591: l_tmpl_name VARCHAR2(100);
592: l_org_id NUMBER;
593: CURSOR org_id_crs IS
594: SELECT authoring_org_id
595: FROM OKC_K_HEADERS_B WHERE document_id=p_doc_id;
596: CURSOR get_unasgn_scn_id_crs IS
597: SELECT ID FROM OKC_SECTIONS_B
598: WHERE document_type = p_doc_type AND document_id = p_doc_id
599: AND scn_code = G_UNASSIGNED_SECTION_CODE;