APPS.OT_WORKFLOW_SS SQL Statements

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

Line: 24

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

Line: 55

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

Line: 90

select standard_price
from   ota_events
where event_id = c_event_id;

Line: 140

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;

Line: 194

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;

Line: 254

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;

Line: 315

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;