DBA Data[Home] [Help]

APPS.CS_KNOWLEDGE_AUDIT_PVT dependencies on CS_KB_SOLN_CATEGORIES_B

Line 3698: from cs_kb_soln_categories_b

3694: -- full_cat_name OUT VARCHAR2
3695: ) RETURN VARCHAR2 IS
3696: cursor c1 is
3697: select category_id
3698: from cs_kb_soln_categories_b
3699: start with category_id = p_catid
3700: connect by prior parent_category_id = category_id;
3701:
3702: Type category_id_tab_type is TABLE OF NUMBER(15) INDEX BY BINARY_INTEGER;

Line 3772: FROM cs_kb_soln_categories_b

3768:
3769: cursor c2(c_id IN NUMBER) is
3770: select tl.name
3771: from ( SELECT category_id, level lev
3772: FROM cs_kb_soln_categories_b
3773: START WITH category_id = c_id
3774: CONNECT BY prior parent_category_id = category_id
3775: ) b, cs_kb_soln_categories_tl tl
3776: where