The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT label_description
FROM gr_labels_tl
WHERE label_code = p_label_code
AND language = userenv('LANG');
SELECT data_type, qcassy_typ_id, lm_unit_code, lowerbound_num,
upperbound_num, lowerbound_char, upperbound_char, organization_id, tech_parm_id
FROM lm_tech_hdr
WHERE organization_id = p_organization_id
AND tech_parm_name = X_desc.label_description;
SELECT data_type, qcassy_typ_id, lm_unit_code, lowerbound_num,
upperbound_num, lowerbound_char, upperbound_char, organization_id, tech_parm_id
FROM lm_tech_hdr
WHERE organization_id IS NULL
AND tech_parm_name = X_desc.label_description;
SELECT b.min_value_num, b.max_value_num, b.target_value_num, b.target_value_char, q.test_unit
FROM gmd_spec_tests_b b, gmd_inventory_spec_vrs v, gmd_specifications_b s, gmd_qc_tests_b q
WHERE b.test_id = LocalLabRecord.qcassy_typ_id
AND s.inventory_item_id = p_inventory_item_id
AND b.spec_id = v.spec_id
AND s.spec_id = b.spec_id
AND q.test_id = b.test_id
AND (v.organization_id = p_organization_id OR v.organization_id IS NULL)
AND v.lot_number IS NULL
AND v.subinventory IS NULL;
SELECT num_data
FROM lm_item_dat
WHERE organization_id = p_organization_id
AND tech_parm_name = X_desc.label_description
AND inventory_item_id = p_inventory_item_id
AND tech_parm_id = p_TECH_PARM_ID;
SELECT text_data
FROM lm_item_dat
WHERE organization_id = p_organization_id
AND tech_parm_name = X_desc.label_description
AND inventory_item_id = p_inventory_item_id
AND tech_parm_id = p_TECH_PARM_ID;
SELECT boolean_data
FROM lm_item_dat
WHERE organization_id = p_organization_id
AND tech_parm_name = X_desc.label_description
AND inventory_item_id = p_inventory_item_id
AND tech_parm_id = p_TECH_PARM_ID;
SELECT tech_parm
FROM gr_labels_b
WHERE label_code = p_label_code;