1452: cursor repeat_csr(id1 NUMBER, id2 NUMBER) is
1453: select count(*) from
1454: (
1455: select organization_id, inventory_item_id, category_id, category_set_id
1456: from OKL_FE_RESI_CAT_OBJECTS where resi_category_set_id = id1
1457: intersect
1458: select organization_id, inventory_item_id, category_id, category_set_id
1459: from OKL_FE_RESI_CAT_OBJECTS where resi_category_set_id = id2
1460: );
1455: select organization_id, inventory_item_id, category_id, category_set_id
1456: from OKL_FE_RESI_CAT_OBJECTS where resi_category_set_id = id1
1457: intersect
1458: select organization_id, inventory_item_id, category_id, category_set_id
1459: from OKL_FE_RESI_CAT_OBJECTS where resi_category_set_id = id2
1460: );
1461:
1462: BEGIN
1463: