DBA Data[Home] [Help]

APPS.OTA_TEA_BUS dependencies on HR_ALL_ORGANIZATION_UNITS

Line 244: from hr_all_organization_units

240: from ota_events evt
241: where event_id = p_event_id
242: and (p_organization_id is null or exists
243: (select null
244: from hr_all_organization_units
245: where organization_id = p_organization_id
246: ))
247: and (p_job_id is null or exists
248: (select null