The following lines contain the word 'select', 'insert', 'update' or 'delete':
G_DML_UPDATE CONSTANT VARCHAR2(1) := 'U';
G_DML_DELETE CONSTANT VARCHAR2(1) := 'D';
select unit_config_header_id
FROM ahl_unit_header_details_v
where name = p_pc_unit_name;
SELECT unit_config_header_id
FROM ahl_unit_config_headers
WHERE name = p_pc_unit_name;
select inventory_item_id
FROM mtl_system_items_kfv
where concatenated_segments = p_pc_part_name;
ELSIF (p_x_assos_tbl(i).operation_flag = G_DML_DELETE)
THEN
IF (p_x_assos_tbl(i).association_type_flag = G_UNIT)
THEN
IF p_module_type IS NULL OR p_module_type = 'JSP'
THEN
p_x_assos_tbl(i).unit_item_id := NULL;