1472: cursor repeat_csr(id1 NUMBER, id2 NUMBER) is
1473: select count(*) from
1474: (
1475: select organization_id, inventory_item_id, category_id, category_set_id
1476: from OKL_FE_RESI_CAT_OBJECTS where resi_category_set_id = id1
1477: intersect
1478: select organization_id, inventory_item_id, category_id, category_set_id
1479: from OKL_FE_RESI_CAT_OBJECTS where resi_category_set_id = id2
1480: );
1475: select organization_id, inventory_item_id, category_id, category_set_id
1476: from OKL_FE_RESI_CAT_OBJECTS where resi_category_set_id = id1
1477: intersect
1478: select organization_id, inventory_item_id, category_id, category_set_id
1479: from OKL_FE_RESI_CAT_OBJECTS where resi_category_set_id = id2
1480: );
1481:
1482: BEGIN
1483: