APPS.OTA_LRNR_ENROLL_UNENROLL_WF SQL Statements

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

Line: 27

SELECT wrpv.display_name displayName
FROM   wf_runnable_processes_v wrpv
WHERE wrpv.item_type = p_itemtype
AND wrpv.process_name = p_process;

Line: 34

select ctl.name, ctb.initial_completion_date,ctb.initial_completion_duration
from ota_Certifications_tl ctl , ota_Certifications_b ctb
where ctl.certification_id = ctb.certification_id
and ctl.Language= USERENV('LANG')
and ctl.certification_id= p_certificationid;

Line: 45

  select hr_workflow_item_key_s.nextval
  into   l_item_key
  from   sys.dual;

Line: 173

SELECT wrpv.display_name displayName
FROM   wf_runnable_processes_v wrpv
WHERE wrpv.item_type = p_itemtype
AND wrpv.process_name = p_process;

Line: 180

select evt.title,oev.course_start_date,
       oev.course_end_date, oev.course_start_time,
       ctl.category,
       ota_general.get_location_code(oev.location_id) Location_Name,
       oav.version_name,ota_timezone_util.get_timezone_name(oev.timezone),oev.course_end_time
from ota_Events oev , ota_events_tl evt,ota_activity_versions_tl oav,
OTA_CATEGORY_USAGES_TL ctl,ota_offerings off
where oev.event_id = evt.event_id
and oev.parent_offering_id=off.offering_id
	and off.activity_version_id= oav.activity_version_id
	and ctl.Category_usage_id = off.delivery_mode_id
AND    ctl.language = userenv('LANG')
	and oev.event_id= p_eventid;

Line: 199

  select hr_workflow_item_key_s.nextval
  into   l_item_key
  from   sys.dual;

Line: 366

select evt.title,oev.course_start_date,
       oav.version_name
from ota_Events oev , ota_events_tl evt,ota_activity_versions_tl oav
where oev.event_id = evt.event_id
	and oev.activity_version_id= oav.activity_version_id
AND    evt.language = userenv('LANG')
	and oev.event_id= p_eventid;

Line: 379

  select hr_workflow_item_key_s.nextval
  into   l_item_key
  from   sys.dual;