APPS.AMS_MTL_CATG_LOADER_PVT dependencies on ENI_PROD_DEN_HRCHY_PARENTS_V

Line 330: from ENI_PROD_DEN_HRCHY_PARENTS_V);

326: WHERE level_type_code = 'FAMILY'
327: and category_id is not null
328: and category_set_id is not null
329: and category_set_id not in (select distinct category_set_id
330: from ENI_PROD_DEN_HRCHY_PARENTS_V);
331:
332: l_activity_product_id NUMBER;
333: l_category_set_id NUMBER;
334: l_category_id NUMBER;