APPS.OKC_XPRT_INT_GRP dependencies on OKC_SECTIONS_B

Line 54: FROM okc_sections_b

50: l_num_scheme_id NUMBER:=0;
51:
52: Cursor c_doc_sections Is
53: SELECT id,scn_id,level,object_version_number, 0
54: FROM okc_sections_b
55: CONNECT BY prior id = scn_id
56: START WITH DOCUMENT_ID = p_document_id and document_type = p_document_type
57: ORDER BY level DESC;
58:

Line 75: TYPE IdList IS TABLE OF okc_sections_b.id%TYPE INDEX BY BINARY_INTEGER;

71: FROM okc_template_usages
72: WHERE document_type = p_document_type
73: AND document_id = p_document_id;
74:
75: TYPE IdList IS TABLE OF okc_sections_b.id%TYPE INDEX BY BINARY_INTEGER;
76:
77: -- define table list for the above cursor with a processed flag (deletable or not)
78: -- if a section cannot be deleted, that section along with all its parent will be marked
79: -- as not deletable