The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT gmt_deviation_hours
INTO l_client_offset
FROM hz_timezones
WHERE timezone_id = g_client_id;
SELECT gmt_deviation_hours
INTO l_server_offset
FROM hz_timezones
WHERE timezone_id = g_server_id;
SELECT start_time
INTO l_start_time
FROM wip_lines
WHERE organization_id = p_org_id
AND (disable_date IS NULL
OR disable_date > Sysdate)
AND ROWNUM=1
ORDER BY line_code;