The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT DISTINCT ITEM_TYPE
INTO c_item_type
FROM HR_API_TRANSACTION_STEPS
WHERE TRANSACTION_ID=p_transaction_id;
SELECT DISTINCT ITEM_KEY
INTO c_item_key
FROM HR_API_TRANSACTION_STEPS
WHERE TRANSACTION_ID=p_transaction_id;
select standard_price
from ota_events
where event_id = c_event_id;
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;*/
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)));
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;
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)));
Select parent_offering_id
From ota_events
Where event_id = c_event_id;
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;
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;
Select oev.title
From ota_events_tl oev
Where oev.language = USERENV ('LANG')
And oev.event_id = c_event_id;
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;
select renewable_flag from ota_certifications_b
where certification_id = c_certification_id;
select initial_completion_duration from ota_certifications_b
where certification_id = c_certification_id;
select renewal_duration from ota_certifications_b
where certification_id = c_certification_id;
select validity_duration from ota_certifications_b
where certification_id = c_certification_id;
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;
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;
select INITIAL_COMPLETION_DATE
from ota_certifications_b
where
certification_id = c_certification_id;