The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT lot_id, lot_no , sublot_no ,expire_date ,
retest_date , item_id , created_by
FROM ic_lots_mst
WHERE delete_mark = 0 AND inactive_ind = 0
FOR UPDATE; -- table is NOT updated, see NOTES section above
SELECT SYSDATE INTO l_date_at_start FROM DUAL ;
SELECT lot_ctl,grade_ctl
INTO l_lot_ctl,l_grade_ctl
FROM ic_item_mst
WHERE item_id = ic_lots_mst_record.item_id
AND delete_mark = 0 ;
SELECT nvl(lot_retest_note,0),nvl(lot_expiry_note,0)
INTO l_retest_interval_from_tab, l_expiry_interval_from_tab
FROM sy_wf_item_roles
WHERE item_id = ic_lots_mst_record.item_id;