The following lines contain the word 'select', 'insert', 'update' or 'delete':
select uom_code
from OKC_TIME_CODE_UNITS_V
where tce_code = cp_tce_code and quantity = cp_quantity
and active_flag = 'Y';
SELECT 1
FROM okx_units_of_measure_v
WHERE uom_code = p_uom_code;
SELECT 1
FROM MTL_UNITS_OF_MEASURE_TL
WHERE uom_code = p_uom_code
AND LANGUAGE = USERENV('LANG');
SELECT tce_code
FROM OKC_TIME_CODE_UNITS_B
WHERE uom_code=p_uom_code;
SELECT 1
FROM MTL_UNITS_OF_MEASURE_TL
WHERE uom_code = p_uom_code
--AND uom_class = 'Time' commented for bug#5585356
AND LANGUAGE = USERENV('LANG');
SELECT 1
FROM MTL_UNITS_OF_MEASURE_TL
WHERE uom_code = p_uom_code
--AND uom_class = 'Time' commented for bug#5585356
AND LANGUAGE = USERENV('LANG');
SELECT 1
FROM MTL_UNITS_OF_MEASURE_TL
WHERE uom_code = p_uom_code
--AND uom_class = 'Time' commented for bug#5585356
AND LANGUAGE = USERENV('LANG');
SELECT 1
FROM MTL_UNITS_OF_MEASURE_TL
WHERE uom_code = p_uom_code
--AND uom_class = 'Time' commented for bug#5585356
AND LANGUAGE = USERENV('LANG');
SELECT tce_code,quantity
FROM okc_time_code_units_b
WHERE uom_code = p_source_uom
AND tce_code in (SELECT tce_code FROM okc_time_code_units_b WHERE uom_code=p_target_uom)
ORDER BY quantity ASC;
SELECT quantity
FROM okc_time_code_units_b
WHERE tce_code = p_source_uom
AND active_flag = 'Y'
AND uom_code = p_target_uom;