APPS.OTA_OTARPBUD_XMLP_PKG SQL Statements

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

Line: 6

select name
from ota_activity_definitions_tl
where activity_id = p_activity_id
and   language = userenv('LANG') ;

Line: 12

select version_name
from ota_activity_versions_tl
where activity_version_id = p_activity_version_id
and   language = userenv('LANG') ;

Line: 18

select title
from ota_events_tl
where event_id = l_event_id
and   language = userenv('LANG') ;

Line: 26

select meaning
from hr_lookups
where lookup_code = l_lookup_code
and lookup_type = 'RESOURCE_BOOKING_STATUS';

Line: 32

select meaning
from hr_lookups
where lookup_code = l_lookup_code
and lookup_type = 'GL_TRANSFER_STATUS';

Line: 90

   select effective_date
   into temp
   from fnd_sessions
   where session_id=userenv('SESSIONID');

Line: 180

   select replace(name,fnd_global.local_chr(10),fnd_global.local_chr(46))
   from hr_all_organization_units org,
        ota_events_vl evt
   where evt.event_id = pevent_id
      and evt.training_center_id = org.organization_id;