APPS.ICX_CAT_SQE_PVT dependencies on ICX_CAT_BROWSE_TREES

Line 603: FROM icx_cat_browse_trees

599: BULK COLLECT INTO l_category_ids
600: FROM icx_cat_categories_tl
601: WHERE type = 2
602: AND rt_category_id in (SELECT child_category_id
603: FROM icx_cat_browse_trees
604: START WITH parent_category_id = p_category_ids(i)
605: CONNECT BY NOCYCLE PRIOR child_category_id = parent_category_id
606: UNION ALL
607: SELECT p_category_ids(i)