APPS.OKC_CLS_UTIL dependencies on OKC_SECTIONS_B

Line 354: l_section_id okc_sections_b.id%TYPE;

350:
351: TYPE art_ver_ids_tbl IS TABLE OF art_ver_id INDEX BY BINARY_INTEGER;
352:
353: l_art_ver_ids_tbl art_ver_ids_tbl;
354: l_section_id okc_sections_b.id%TYPE;
355: l_api_version CONSTANT NUMBER := 1;
356: l_section_present_in_lib VARCHAR2(1);
357: l_section_id_found VARCHAR2(1);
358: l_wrong_version_found VARCHAR2(1);

Line 386: FROM okc_sections_b

382: EXIT WHEN cur_distinct_sections_in_xml%NOTFOUND;
383: BEGIN
384: SELECT id
385: INTO l_section_id
386: FROM okc_sections_b
387: WHERE heading = l_xml_section_name
388: AND DOCUMENT_TYPE = p_doc_type
389: AND DOCUMENT_ID = p_doc_id
390: AND ROWNUM = 1;