APPS.OTA_REPROCESS_CLASSIC_UPGRADE dependencies on OTA_CATEGORY_USAGES_TL
Line 178: from ota_category_usages_tl oct
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 179: where oct.category_usage_id = ocu.category_usage_id)
180: and rownum = 1 ;
181:
182: l_exists boolean := false;