The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT structure_type_id
INTO l_structure_type_id
FROM bom_structure_types_b
WHERE structure_type_name = nvl(p_struct_type,'All-Structure Types');
SELECT structure_type_id
INTO l_pkghier_type_id
FROM bom_structure_types_b
WHERE structure_type_name = 'Packaging Hierarchy';
SELECT fnd_global.resp_appl_id INTO resp_appl_id
FROM dual;