The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT loct_onhand, lot_status
FROM ic_loct_inv
WHERE item_id = p_item_id
AND whse_code = p_whse_code
AND lot_id = p_lot_id
AND location = p_location;
SELECT lot_no, sublot_no
FROM ic_lots_mst
WHERE lot_id = p_lot_id;
SELECT reason_code
FROM sy_reas_cds
WHERE delete_mark = 0
AND (l_reason_code_security = 'Y')
AND (reason_code in (select reason_code from gma_reason_code_security
where (doc_type = 'PORC' or doc_type IS NULL) and
(responsibility_id = FND_GLOBAL.RESP_id or responsibility_id IS NULL)))
UNION ALL
SELECT reason_code
FROM sy_reas_cds
WHERE delete_mark = 0;
SELECT *
INTO l_item_rec
FROM ic_item_mst
WHERE item_id = p_item_id;
SELECT s.co_code, w.orgn_code
INTO l_trans_rec.co_code, l_trans_rec.orgn_code
FROM ic_whse_mst w, sy_orgn_mst s
WHERE w.whse_code = p_whse_code
AND w.orgn_code = s.orgn_code;
UPDATE IC_LOCT_INV
SET lot_status = p_to_status
WHERE item_id = p_item_id
AND whse_code = p_whse_code
AND location = p_location
AND lot_id = p_lot_id;
SELECT lot_id,lot_status
FROM ic_tran_pnd
WHERE doc_type = 'OMSO'
AND item_id = p_item_id
AND completed_ind = 1
AND delete_mark = 0
AND line_id IN(SELECT line_id FROM oe_order_lines_all
WHERE source_document_line_id = p_req_line_id);
x_lot_sts_tab.DELETE;