170: cursor c_exist is
171: select 1
172: from ota_category_usages ocu
173: where ocu.category = (SELECT lkp.meaning
174: FROM hr_lookups lkp
175: WHERE lkp.lookup_code = ocu.category
176: AND lkp.lookup_type = 'ACTIVITY_CATEGORY')
177: or not exists (select 1
178: from ota_category_usages_tl oct