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 oad.name
from ota_events evt,
ota_activity_versions oav,
ota_activity_definitions_tl oad
where evt.event_id = c_event_id and
oad.language=userenv('LANG') and
evt.activity_version_id = oav.activity_version_id and
oav.activity_id = oad.activity_id;
select
hl.meaning
from
ota_events evt,
ota_act_cat_inclusions oac,
ota_category_usages ocu,
hr_lookups hl
where evt.event_id = c_event_id and
evt.activity_version_id = oac.activity_version_id and
oac.category_usage_id = ocu.category_usage_id and
ocu.type = 'C' and
oac.primary_flag = 'Y' and
hl.lookup_type = 'ACTIVITY_CATEGORY' and
oac.activity_category = hl.lookup_code;
select
hl.meaning
from
ota_events evt,
ota_act_cat_inclusions oac,
ota_category_usages ocu,
hr_lookups hl
where evt.event_id = c_event_id and
evt.activity_version_id = oac.activity_version_id and
oac.category_usage_id = ocu.category_usage_id and
ocu.type = 'DM' and
oac.primary_flag = 'Y' and
hl.lookup_type = 'ACTIVITY_CATEGORY' and
oac.activity_category = hl.lookup_code;
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;