APPS.CS_KB_SOLN_CATEGORIES_PVT dependencies on CS_KB_SOLN_CATEGORIES_TL

Line 645: ) b, cs_kb_soln_categories_tl tl, cs_kb_cat_group_denorm mv

641: from ( SELECT category_id, level lev
642: FROM cs_kb_soln_categories_b
643: START WITH category_id = p_cat_id
644: CONNECT BY prior parent_category_id = category_id
645: ) b, cs_kb_soln_categories_tl tl, cs_kb_cat_group_denorm mv
646: where
647: b.category_id = tl.category_id
648: and tl.language = userenv( 'LANG' )
649: and tl.category_id = mv.child_category_id

Line 688: ) b, cs_kb_soln_categories_tl tl

684: from ( SELECT category_id, level lev
685: FROM cs_kb_soln_categories_b
686: START WITH category_id = cat_id
687: CONNECT BY prior parent_category_id = category_id
688: ) b, cs_kb_soln_categories_tl tl
689: where
690: b.category_id = tl.category_id
691: and tl.language = userenv( 'LANG' )
692: order by b.lev desc;