DBA Data[Home] [Help]

APPS.CS_KNOWLEDGE_AUDIT_PVT dependencies on CS_KB_SOLN_CATEGORIES_B

Line 3688: from cs_kb_soln_categories_b

3684: -- full_cat_name OUT VARCHAR2
3685: ) RETURN VARCHAR2 IS
3686: cursor c1 is
3687: select category_id
3688: from cs_kb_soln_categories_b
3689: start with category_id = p_catid
3690: connect by prior parent_category_id = category_id;
3691:
3692: Type category_id_tab_type is TABLE OF NUMBER(15) INDEX BY BINARY_INTEGER;

Line 3762: FROM cs_kb_soln_categories_b

3758:
3759: cursor c2(c_id IN NUMBER) is
3760: select tl.name
3761: from ( SELECT category_id, level lev
3762: FROM cs_kb_soln_categories_b
3763: START WITH category_id = c_id
3764: CONNECT BY prior parent_category_id = category_id
3765: ) b, cs_kb_soln_categories_tl tl
3766: where