APPS.OTA_REPROCESS_CLASSIC_UPGRADE dependencies on OTA_RESOURCE_USAGES

Line 253: or ( exists (select 1 from ota_resource_usages rud where rud.activity_version_id = tav.activity_version_id)

249: FROM ota_activity_versions tav
250: WHERE
251: not exists (select 1 from ota_offerings off where off.activity_version_id = tav.activity_version_id )
252: and ( exists (select 1 from ota_events evt where evt.activity_version_id = tav.activity_version_id )
253: or ( exists (select 1 from ota_resource_usages rud where rud.activity_version_id = tav.activity_version_id)
254: and not exists (select 1 from ota_resource_usages rud1 where rud1.activity_version_id= tav.activity_version_id
255: and rud1.offering_id is null))
256: or ( exists ( select 1 from per_competence_elements where object_id = tav.activity_version_id and type = 'TRAINER')
257: and not exists (select 1 from per_competence_elements where object_id = tav.activity_version_id and type = 'OTA_OFFERING')))

Line 254: and not exists (select 1 from ota_resource_usages rud1 where rud1.activity_version_id= tav.activity_version_id

250: WHERE
251: not exists (select 1 from ota_offerings off where off.activity_version_id = tav.activity_version_id )
252: and ( exists (select 1 from ota_events evt where evt.activity_version_id = tav.activity_version_id )
253: or ( exists (select 1 from ota_resource_usages rud where rud.activity_version_id = tav.activity_version_id)
254: and not exists (select 1 from ota_resource_usages rud1 where rud1.activity_version_id= tav.activity_version_id
255: and rud1.offering_id is null))
256: or ( exists ( select 1 from per_competence_elements where object_id = tav.activity_version_id and type = 'TRAINER')
257: and not exists (select 1 from per_competence_elements where object_id = tav.activity_version_id and type = 'OTA_OFFERING')))
258: and rownum =1;