APPS.OTA_OTARPREG_XMLP_PKG SQL Statements

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

Line: 21

Select title
from ota_events_tl
where event_id = p_event_id
and   language = userenv('LANG');

Line: 27

Select name
from hr_all_organization_units org
where ORG.ORGANIZATION_ID = center_id;

Line: 113

  select fnd_date.date_to_displaydate(sysdate,calendar_aware)
  into cp_current_date
  from dual;

Line: 126

   select replace(name,fnd_global.local_chr(10),fnd_global.local_chr(46))
   into cp_venue
   from ota_suppliable_resources_tl sr,
        ota_resource_bookings rb
   where rb.event_id = cf_venueformula.event_id
      and rb.primary_venue_flag = 'Y'
      and sr.supplied_resource_id = rb.supplied_resource_id
      and sr.language = userenv('LANG') ;

Line: 146

    select fnd_date.date_to_displaydate((p_session_date),calendar_aware)    into cp_session_date
  from dual;

Line: 154

  select fnd_date.date_to_displaydate(to_date(substr((p_course_start_date),1,10),'yyyy/mm/dd'))
  into cp_course_start_date
  from dual;

Line: 163

  select fnd_date.date_to_displaydate(to_date(substr((p_course_end_date),1,10),'yyyy/mm/dd'))
  into cp_course_end_date
  from dual;