The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT schedule_item_id
FROM chv_schedule_items
WHERE schedule_id = p_schedule_id
AND rebuild_flag = 'Y';
SELECT bucket_pattern_id,
vendor_id,
vendor_site_id,
organization_id,
mrp_compile_designator,
mps_schedule_designator,
drp_compile_designator,
schedule_subtype,
schedule_type,
schedule_horizon_start,
include_future_releases_flag
INTO x_bucket_pattern_id,
x_vendor_id,
x_vendor_site_id,
x_organization_id,
x_mrp_compile_designator,
x_mps_schedule_designator,
x_drp_compile_designator,
x_schedule_subtype,
x_schedule_type,
x_horizon_start_date,
x_include_future_releases
FROM chv_schedule_headers
WHERE schedule_id = p_schedule_id;
DELETE FROM chv_item_orders
WHERE schedule_id = p_schedule_id
AND schedule_item_id = x_schedule_item_id;
DELETE FROM chv_horizontal_schedules
WHERE schedule_id = p_schedule_id
AND schedule_item_id = x_schedule_item_id;
DELETE from chv_authorizations
WHERE reference_id = x_schedule_item_id
AND reference_type = 'SCHEDULE_ITEMS';