APPS.OTA_AME_ATTRIBUTES SQL Statements

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

Line: 22

SELECT DISTINCT ITEM_TYPE
INTO c_item_type
FROM HR_API_TRANSACTION_STEPS
WHERE TRANSACTION_ID=p_transaction_id;

Line: 46

SELECT DISTINCT ITEM_KEY
INTO c_item_key
FROM HR_API_TRANSACTION_STEPS
WHERE TRANSACTION_ID=p_transaction_id;

Line: 78

select standard_price
from   ota_events
where event_id = c_event_id;

Line: 131

 select olpt.name
from ota_events oev,ota_training_plans otp, ota_training_plan_members otpm,
ota_learning_paths_tl olpt
where oev.activity_version_id = otpm.activity_version_id
and otpm.member_status_type_id='OTA_COMPLETED'
and otpm.training_plan_id=otp.training_plan_id
and otp.plan_status_type_id='OTA_COMPLETED'
and otp.learning_path_id= olpt.learning_path_id
and olpt.Language=USERENV('LANG')
and oev.event_id=c_event_id;*/

Line: 195

 Select ocu.Category
 From ota_act_cat_inclusions oaci,
      ota_category_usages_vl ocu,
      ota_events oev,
      ota_offerings ofr
 Where oev.event_id = c_event_id
       AND oev.parent_offering_id = ofr.offering_id
       AND ofr.activity_version_id = oaci.activity_version_id
       AND ocu.category_usage_id = oaci.category_usage_id
       AND oaci.primary_flag = 'Y'
       AND ocu.type = 'C'
       AND (TRUNC(sysdate) BETWEEN NVL(TRUNC(oaci.start_date_active), TRUNC(sysdate)) AND nvl(TRUNC(oaci.end_date_active), TRUNC(sysdate)))
       AND (TRUNC(sysdate) BETWEEN NVL(TRUNC(ocu.start_date_active), TRUNC(sysdate)) AND nvl(TRUNC(ocu.end_date_active), TRUNC(sysdate)));

Line: 254

select
       bst.name
from
       ota_delegate_bookings tdb,
       ota_booking_status_types_tl bst
where  tdb.booking_id = c_booking_id and
       bst.language=userenv('LANG') and
       tdb.booking_status_type_id = bst.booking_status_type_id;

Line: 309

 Select ocu.Category
 From ota_offerings ofr,
      ota_category_usages_vl ocu
 Where ofr.offering_id = c_offering_id
       AND ofr.delivery_mode_id = ocu.category_usage_id
       AND ocu.type = 'DM'
       AND (TRUNC(sysdate) BETWEEN NVL(TRUNC(ocu.start_date_active), TRUNC(sysdate))
       AND nvl(TRUNC(ocu.end_date_active), TRUNC(sysdate)));

Line: 319

 Select parent_offering_id
 From ota_events
 Where event_id = c_event_id;

Line: 371

 Select oav.version_name
 From ota_events oev,
      ota_activity_versions_tl oav
 Where oev.activity_version_id = oav.activity_version_id
       And oav.language = USERENV ('LANG')
       And oev.event_id = c_event_id;

Line: 420

 Select ofr.name
 From ota_events oev,
      ota_offerings_tl ofr
 Where oev.parent_offering_id = ofr.offering_id
       And ofr.language = USERENV ('LANG')
       And oev.event_id = c_event_id;

Line: 469

 Select oev.title
 From ota_events_tl oev
 Where oev.language = USERENV ('LANG')
       And oev.event_id = c_event_id;

Line: 516

 Select ota_general.get_location_code(ota_utility.get_event_location(oev.event_id)) Location_Name
 From ota_events oev
 Where oev.event_id = c_event_id;

Line: 599

select renewable_flag from ota_certifications_b
where certification_id = c_certification_id;

Line: 647

select initial_completion_duration from ota_certifications_b
where certification_id = c_certification_id;

Line: 695

select renewal_duration from ota_certifications_b
where certification_id = c_certification_id;

Line: 742

select validity_duration from ota_certifications_b
where certification_id = c_certification_id;

Line: 795

select cpe.cert_period_start_date
from ota_cert_prd_enrollments cpe , ota_cert_enrollments ce
where
ce.cert_enrollment_id = cpe.cert_enrollment_id
and ce.certification_id = c_certification_id
and ce.person_id = c_person_id
and cpe.period_status_code = 'CANCELLED'
and rownum =1
order by cert_period_start_date desc;

Line: 860

select cpe.cert_period_end_date
from ota_cert_prd_enrollments cpe , ota_cert_enrollments ce
where
ce.cert_enrollment_id = cpe.cert_enrollment_id
and ce.certification_id = c_certification_id
and ce.person_id = c_person_id
and cpe.period_status_code = 'CANCELLED'
and rownum =1
order by cert_period_start_date desc;

Line: 925

select INITIAL_COMPLETION_DATE
from ota_certifications_b
where
certification_id = c_certification_id;