659: END IF;
660: BEGIN
661: SELECT Category_id
662: INTO l_old_category_id
663: FROM Mtl_Categories_B_Kfv
664: WHERE Structure_Id = ( SELECT Structure_Id
665: FROM mtl_category_sets_vl
666: WHERE category_set_id = l_category_set_id )
667: AND Concatenated_Segments = icoi_rec.old_category_name;
735: FROM mtl_category_sets_b
736: WHERE category_set_id = l_category_set_id;
737: END IF;
738: SELECT category_id INTO l_category_id
739: FROM mtl_categories_b_kfv
740: WHERE concatenated_segments = icoi_rec.category_name
741: -- bug 3500492
742: AND structure_id = l_structure_id
743: AND NVL(disable_date,SYSDATE+1) > SYSDATE;