APPS.CS_KB_SOLN_CATEGORIES_PVT dependencies on CS_KB_CAT_GROUP_DENORM

Line 369: FROM CS_KB_CAT_GROUP_DENORM

365: ORDER BY level asc;
366:
367: CURSOR GET_DUP_CG_MEMBERSHIP(cp_category_id number) IS
368: SELECT Distinct Category_Group_Id
369: FROM CS_KB_CAT_GROUP_DENORM
370: WHERE CHILD_CATEGORY_ID = P_PARENT_CATEGORY_ID
371: intersect
372: select distinct m.category_group_id
373: FROM CS_KB_CAT_GROUP_MEMBERS m

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