APPS.OTA_GENERAL SQL Statements

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

Line: 73

SELECT  title from ota_events_vl
where
event_id = p_event_id;

Line: 95

SELECT name from ota_offerings_tl
where
language=userenv('LANG')
and
offering_id = p_offering_id;

Line: 119

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

Line: 126

SELECT oav.version_name
FROM OTA_ACTIVITY_VERSIONS_TL oav,ota_events oev
WHERE oav.activity_version_id = oev.activity_version_id
AND oav.language=userenv('LANG')
and oev.event_id = p_eventid;

Line: 166

    select 'X'
    from per_all_people_f ppf,
    per_person_type_usages_f ptu,
    per_person_types ppt
    where p_date between ptu.effective_start_date and ptu.effective_end_date
    and   p_date between ppf.effective_start_date and ppf.effective_end_date
    and	  ptu.person_id = ppf.person_id
    and   ppt.system_person_type in ('EMP','CWK','APL')  -- Added 'APL' for 3885568
    and   ppt.business_group_id = ppf.business_group_id
    and   ptu.person_type_id = ppt.person_type_id
    and   ppf.person_id = p_person_id ;

Line: 212

        select  1
        from    hr_lookups
        where   lookup_type  =  p_domain_type
        and     lookup_code  =  p_domain_value;

Line: 474

select user_name
from fnd_user
where user_id = p_user_id;

Line: 495

    select effective_date
    from   fnd_sessions
    where  session_id = p_session_id;

Line: 520

select 'Y'
from fnd_user
where user_id = p_user_id;

Line: 550

    select 'X'
    from per_all_people_f
    where person_id = p_person_id
      and l_date between effective_start_date and effective_end_date;

Line: 672

        select  1
        from    fnd_currencies
        where   currency_code = p_currency_code;

Line: 713

        select  1
        from    fnd_languages
        where   language_id = p_language_id;

Line: 750

        select  vendor_name
        from    po_vendors
        where   vendor_id = p_vendor_id;

Line: 779

        select  1
        from    po_vendors
        where   vendor_name = p_vendor_name;

Line: 807

        select  1
        from    po_vendors
        where   vendor_id = p_vendor_id
	and nvl(end_date_active,to_date('31-12-4712', 'DD-MM-YYYY')) > l_date;

Line: 838

  select description
   from fnd_languages_vl
   where language_id  = p_language_id;

Line: 864

select orgs_tl.name
from hr_all_organization_units orgs,hr_all_organization_units_tl orgs_tl
where orgs.organization_id = p_organization_id
      and orgs.organization_id = orgs_tl.organization_id
      and orgs_tl.language = userenv('LANG');

Line: 895

  select name
   from fnd_currencies_vl
   where currency_code  = p_currency_code;

Line: 920

  select language_code
   from fnd_languages_vl
   where language_id  = p_language_id;

Line: 959

                      ,p_update_scheduled_event    out nocopy varchar2
                      ,p_autogen_development_event out nocopy varchar2
                      ,p_update_development_event  out nocopy varchar2) is
cursor get_default_values is
select null
,      null
,      null
,      null
,      null
,      null
,      null
,      null
from sys.dual;

Line: 979

                                ,p_update_scheduled_event
                                ,p_autogen_development_event
                                ,p_update_development_event;

Line: 992

l_update_scheduled_event    varchar2(30);

Line: 994

l_update_development_event  varchar2(30);

Line: 1002

              ,l_update_scheduled_event
              ,l_autogen_development_event
              ,l_update_development_event);

Line: 1015

                      ,p_update_scheduled_event  out nocopy varchar2) is
begin
   null;

Line: 1021

                      ,p_update_development_event  out nocopy varchar2) is
begin
   null;

Line: 1063

SELECT  org.name
FROM  hr_all_organization_units org, hr_organization_information ori
WHERE org.business_group_id = l_business_group_id
      AND org.organization_id = p_training_center_id
      AND org.organization_id = ori.organization_id
      AND ori.org_information_context = 'CLASS'
      AND ori.org_information1 ='OTA_TC';

Line: 1088

SELECT  loc.location_code
FROM  hr_locations_all  loc
WHERE loc.Location_id = p_location_id;

Line: 1107

  SELECT count(*) total
  FROM ota_finance_lines fl,
  ota_finance_headers fh
  where fl.booking_id = p_booking_id and
  fh.finance_header_id = fl.Finance_header_id and
   fh.type= 'CT' and
   fl.cancelled_flag  ='Y';

Line: 1136

SELECT loc.location_code
  FROM hr_locations_all_tl loc
 WHERE loc.location_id = p_location_id
   AND loc.language = USERENV('LANG');

Line: 1179

SELECT org.name
  FROM hr_all_organization_units_tl org
 WHERE org.organization_id = p_organization_id
   AND org.language = USERENV('LANG');

Line: 1222

    SELECT PBG.legislation_code
    FROM per_business_groups PBG
    WHERE PBG.business_group_id = ota_general.get_business_group_id;