eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OTA_EL_ENROLL_SS SQL Statements

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

Line: 73


SELECT hao.business_group_id,
       evt.organization_id,
       evt.currency_code,
       evt.course_start_date,
       evt.course_end_date,
       evttl.Title,
       evt.owner_id,
       evt.activity_version_id,
       evt.offering_id
FROM   OTA_EVENTS   evt,
       OTA_EVENTS_TL  evttl,
       HR_ALL_ORGANIZATION_UNITS  hao
WHERE  evt.event_id = pp_event_id
	AND evt.event_id = evttl.event_id
	AND evt.organization_id = hao.organization_id (+)
	AND evttl.language(+) = userenv('LANG'); -- Bug 2213009

Line: 92


Select event_status, maximum_internal_attendees
from   OTA_EVENTS
WHERE  EVENT_ID = TO_NUMBER(p_event_id);

Line: 97


SELECT count(*)
FROM   OTA_DELEGATE_BOOKINGS dbt,
       OTA_BOOKING_STATUS_TYPES bst
WHERE  dbt.event_id = TO_NUMBER(p_event_id)
AND    dbt.internal_booking_flag = 'Y'
AND    dbt.booking_status_type_id = bst.booking_status_type_id
AND    bst.type in ('P','A','E');

Line: 107


SELECT nvl(price_basis,NULL)
FROM ota_events
where event_id = p_event_id;

Line: 112


SELECT
 USER_NAME
FROM
 FND_USER
WHERE
Employee_id = p_owner_id ;

Line: 121


SELECT  version_name
FROM  OTA_ACTIVITY_VERSIONS_TL
WHERE  activity_version_id = p_activity_version_id AND language(+) = userenv('LANG');

Line: 727


			UPDATE ota_finance_lines SET transfer_status = 'AT'
			WHERE finance_line_id = l_finance_line_id;

Line: 883


SELECT FLN.finance_line_id	       finance_line_id,
	   FLN.finance_header_id       finance_header_id,
	   FLN.transfer_status	       transfer_status,
	   FLN.booking_id		       booking_id,
       FLN.object_version_number   object_version_number,
	   FLN.sequence_number         sequence_number,
       FLN.Cancelled_flag          cancelled_flag
  FROM OTA_FINANCE_LINES FLN
 WHERE FLN.booking_id = p_booking_id;

Line: 894


SELECT 	count(*)
  FROM	OTA_FINANCE_LINES	FLN
 WHERE	FLN.finance_header_id = p_finance_header_id;

Line: 899


SELECT FLH.finance_header_id	   finance_header_id,
	   FLH.cancelled_flag	       cancelled_flag,
	   FLH.transfer_status	       transfer_status,
	   FLH.object_version_number   object_version_number
  FROM OTA_FINANCE_HEADERS	FLH,
	   OTA_FINANCE_LINES    FLN
 WHERE FLH.finance_header_id  =   FLN.finance_header_id
   AND FLN.booking_id         =   p_booking_id;

Line: 1097


SELECT assg.assignment_id,
assg.business_group_id,
assg.organization_id,
pcak.cost_allocation_keyflex_id,
pcak.concatenated_segments,
pcaf.proportion
FROM per_all_people_f ppf,
per_all_assignments_f assg,
pay_cost_allocations_f pcaf,
pay_cost_allocation_keyflex pcak
WHERE ppf.person_id = p_person_id
AND ppf.person_id = assg.person_id
AND assg.assignment_id = pcaf.assignment_id
AND assg.Primary_flag = 'Y'
AND pcaf.cost_allocation_keyflex_id = pcak.cost_allocation_keyflex_id
AND pcak.enabled_flag = 'Y'
AND sysdate between nvl(pcaf.effective_start_date,sysdate)
and nvl(pcaf.effective_end_date,sysdate+1)
AND sysdate between nvl(assg.effective_start_date,sysdate)
and nvl(assg.effective_end_date,sysdate+1)
AND sysdate between nvl(ppf.effective_start_date,sysdate)
and nvl(ppf.effective_end_date,sysdate+1);

Line: 1122


SELECT   assg.assignment_id,
         assg.business_group_id,
         assg.organization_id
FROM     per_all_people_f                ppf,
         per_all_assignments_f           assg
WHERE    ppf.person_id                      = p_delegate_id
AND      ppf.person_id                   = assg.person_id
AND      sysdate between nvl(assg.effective_start_date,sysdate)
         and nvl(assg.effective_end_date,sysdate+1)
AND      assg.primary_flag = 'Y'
AND      sysdate between nvl(ppf.effective_start_date,sysdate)
         and nvl(ppf.effective_end_date,sysdate+1);

Line: 1216


SELECT
 EMPLOYEE_ID
FROM
 FND_USER
WHERE
 user_id = l_current_user_id ;

Line: 1232


  select hr_workflow_item_key_s.nextval
  into   l_item_key
  from   sys.dual;

Line: 1438


  SELECT ov.booking_id
  FROM   ota_booking_status_types os,
         ota_delegate_bookings ov
  WHERE  ov.event_id = p_event_id
  AND    ov.delegate_person_id = p_person_id
  AND    os.booking_status_type_id = ov.booking_status_type_id
  AND    os.type = 'C';

Line: 1449


  SELECT ov.booking_id
  FROM   ota_booking_status_types os,
         ota_delegate_bookings ov
  WHERE  ov.event_id = p_event_id
  AND    ov.delegate_person_id = p_person_id
  AND    os.booking_status_type_id = ov.booking_status_type_id
  AND    os.type <> 'C';

Line: 1564


 SELECT secure_event_flag,organization_id
 from ota_events
 where event_id = p_event_id;

Line: 1569


 SELECT organization_id
 from per_all_assignments_f
 where person_id = p_delegate_id and
       trunc(sysdate) between effective_start_date and
effective_end_date;

Line: 1631


  SELECT ea.organization_id, ea.job_id, ea.position_id
  FROM   ota_event_associations ea
  WHERE  ea.event_id = p_event_id;

Line: 1637


  SELECT course_start_date
  --  FROM otv_scheduled_events
      FROM ota_events
   WHERE event_id = p_event_id and
  --Bug#2201434  SELFPACED event_type included.
  --     event_type='SCHEDULED' and
         event_type in ('SCHEDULED','SELFPACED') and
         event_status in('P','N','F')and
         TRUNC(SYSDATE) BETWEEN NVL( ENROLMENT_START_DATE, TRUNC(
SYSDATE)) AND
         NVL( ENROLMENT_END_DATE, TRUNC( SYSDATE)) AND
         TRUNC(SYSDATE) <= NVL( COURSE_END_DATE, TRUNC(SYSDATE));

Line: 1656


  SELECT paf.assignment_id
  FROM per_all_assignments_f paf
  WHERE paf.person_id            = p_delegate_id
  AND NVL(p_course_start_date,trunc(sysdate)) BETWEEN
paf.effective_start_date AND paf.effective_end_date
  AND NVL(p_organization_id, -1) = DECODE(p_organization_id, null, -1,
NVL(paf.organization_id,-1))
  AND NVL(p_job_id, -1)          = DECODE(p_job_id, null, -1,
NVL(paf.job_id, -1))
  AND NVL(p_position_id,-1)      = DECODE(p_position_id, null, -1,
NVL(paf.position_id, -1))
  AND paf.assignment_type        = 'E';

Line: 1871


        SELECT null
     FROM wf_item_activity_statuses_v wf
     WHERE activity_name = p_activity
           AND activity_status_code = 'NOTIFIED'
           AND item_type = p_item_type
                 AND item_key = p_item_key;

Line: 1904


SELECT usr.user_name,
       evt.offering_id
FROM   OTA_EVENTS 	evt,
       FND_USER        USR
WHERE  evt.event_id = p_event_id and
       usr.employee_id = evt.owner_id;

Line: 1913


SELECT bst.Type
FROM   OTA_DELEGATE_BOOKINGS tdb,
       OTA_BOOKING_STATUS_TYPES bst
WHERE  tdb.booking_id = p_booking_id
AND    bst.booking_status_type_id = tdb.booking_status_type_id;

Line: 2077


 SELECT EVT.public_event_flag,EVT.maximum_internal_attendees
 from ota_events EVT, ota_event_associations EVA
 where EVT.event_id = p_event_id and
       EVT.event_id = EVA.event_id and
       EVA.customer_id is not null;

Line: 2130


 SELECT activity_version_id,end_date from ota_activity_versions
 where Activity_version_id = l_activity_id
 and developer_organization_id=ota_general.get_business_group_id;

Line: 2134


 SELECT activity_version_id, end_date
 FROM ota_activity_versions tav, ota_activity_definitions tad
 WHERE tav.activity_id = tad.activity_id
 AND tad.business_group_id = ota_general.get_business_group_id
 AND tav.activity_version_id = l_activity_id;

Line: 2143


 SELECT 1 from ota_events
 where Activity_version_id=l_activity_id
 and business_group_id=ota_general.get_business_group_id;

Line: 2200


 SELECT event_id from ota_events
 where event_id = l_event_id;

Line: 2206


 SELECT event_id from ota_events
 where event_id = l_event_id
 And     trunc(sysdate) between nvl(trunc(tav.start_date),trunc(sysdate)) and
              nvl(trunc(tav.end_date),trunc(sysdate))
      And     evt.event_type IN ('SCHEDULED','SELFPACED')
      And     evt.book_independent_flag = 'N'
      And     evt.Event_status in('N','P','F')
      And     trunc(sysdate) between nvl(trunc(evt.enrolment_start_date),trunc(sysdate)) and
              nvl(trunc(evt.enrolment_end_date),trunc(sysdate)) ;

Line: 2219


 SELECT event_id,event_status,course_start_date,course_end_date,enrolment_start_date,
 enrolment_end_date
 from ota_events
 where event_id = l_event_id
 and event_type in ('SCHEDULED','SELFPACED')
 and business_group_id=ota_general.get_business_group_id ;

Line: 2296


      select function_id
      from   fnd_form_functions
      where  function_name = l_function_name;

Line: 2301


      select  fr.menu_id, furg.responsibility_id,
              furg.security_group_id, furg.responsibility_application_id
      from    fnd_responsibility fr,
              fnd_user_resp_groups furg,
              fnd_user fu
      where   fu.USER_ID = l_user_id
      and     fu.START_DATE <= sysdate
      and     (fu.END_DATE is null or fu.END_DATE > sysdate)
      and     furg.USER_ID = fu.USER_ID
      and     furg.START_DATE <= sysdate
      and     (furg.END_DATE is null or furg.END_DATE > sysdate)
      and     furg.RESPONSIBILITY_APPLICATION_ID = fr.APPLICATION_ID
      and     furg.RESPONSIBILITY_ID = fr.RESPONSIBILITY_ID
      and     fr.VERSION = 'W'
      and     fr.START_DATE <= sysdate
      and     (fr.END_DATE is null or fr.END_DATE > sysdate);

Line: 2382


  SELECT object_version_number
  FROM   ota_delegate_bookings
  WHERE  booking_id  = p_booking_id;