APPS.OTA_REPROCESS_CLASSIC_UPGRADE dependencies on HR_LOOKUPS
Line 174: FROM hr_lookups lkp
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