APPS.PER_OTA_PREDEL_VALIDATION SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 19

Select null
from   ota_event_associations
where  job_id =  p_job_id;

Line: 69

Select null
from   ota_event_associations
where  position_id =  p_position_id;

Line: 114

select null
from sys.dual
where exists(select null
             from   ota_events
             where  organization_id = p_organization_id)
   or exists(select null
             from   ota_delegate_bookings
             where  organization_id = p_organization_id)
   or exists(select null
             from   ota_event_associations
             where  organization_id = p_organization_id)
   or exists( select null
              from   ota_finance_headers
              where  organization_id = p_organization_id)
   or exists( select null from   ota_activity_versions
              where  developer_organization_id = p_organization_id)
   or exists( select null from   ota_events
              where  training_center_id = p_organization_id);

Line: 179

select null
from sys.dual
where exists(select null
             from   ota_activity_versions
             where  controlling_person_id = p_person_id)
   or exists(select null
             from   ota_delegate_bookings
             where  delegate_person_id = p_person_id
              or    sponsor_person_id = p_person_id)
   or exists(select null
             from   ota_events
             where  owner_id = p_person_id)
   or exists(select null
             from   ota_notrng_histories
             where  person_id = p_person_id and
                    organization_id is not null);

Line: 237

select null
from   ota_delegate_bookings
where  delegate_assignment_id = p_assignment_id
or        sponsor_assignment_id = p_assignment_id ;