The following lines contain the word 'select', 'insert', 'update' or 'delete':
select standard_type
into l_standard_type
from ecx_standards
where standard_id = p_standard_id;
SELECT standard_id
INTO l_standard_id
FROM ecx_standards
WHERE standard_code = 'CUSTOM'
and standard_type = l_standard_type;
SELECT xref_ext_value
INTO l_ext_val
FROM ecx_xref_dtl
WHERE tp_header_id = p_tp_id AND
xref_int_value = p_tbl(i).value AND
standard_id = l_standard_id AND
xref_category_id = p_tbl(i).xref_category_id AND
direction = 'OUT';
SELECT xref_std_value
INTO l_ext_val
FROM ecx_xref_standards
WHERE standard_id = p_standard_id
AND xref_category_id = p_tbl(i).xref_category_id
AND xref_int_value = p_tbl(i).value;
SELECT standard_id
INTO l_univ_std_id
FROM ecx_standards
WHERE standard_code = 'UNIVERSAL'
and standard_type = l_standard_type;
SELECT xref_std_value
INTO l_ext_val
FROM ecx_xref_standards
WHERE standard_id = l_univ_std_id
AND xref_category_id = p_tbl(i).xref_category_id
AND xref_int_value = p_tbl(i).value;
SELECT xref_int_value
INTO l_int_val
FROM ecx_xref_dtl
WHERE tp_header_id = p_tp_id AND
standard_id = p_standard_id AND
xref_category_id = p_apps_tbl(j).xref_category_id AND
xref_ext_value = p_apps_tbl(j).value AND
direction = 'IN';
SELECT xref_std_value
INTO l_int_val
FROM ecx_xref_standards
WHERE standard_id = p_standard_id
AND xref_category_id = p_apps_tbl(j).xref_category_id
AND xref_int_value = p_apps_tbl(j).value;
select standard_type
into l_standard_type
from ecx_standards
where standard_id = p_standard_id;
SELECT standard_id
INTO l_standard_id
FROM ecx_standards
WHERE standard_code = 'CUSTOM'
and standard_type = l_standard_type;
SELECT xref_int_value
INTO l_int_val
FROM ecx_xref_dtl
WHERE tp_header_id = p_snd_tp_id AND
standard_id = l_standard_id AND
xref_category_id = p_category_id AND
xref_ext_value = p_value AND
direction = 'IN';
SELECT xref_int_value
INTO l_int_val
FROM ecx_xref_standards
WHERE standard_id = p_standard_id
AND xref_category_id = p_category_id
AND xref_std_value = rtrim(p_value);
SELECT standard_id
INTO l_univ_std_id
FROM ecx_standards
WHERE standard_code = 'UNIVERSAL'
and standard_type = l_standard_type;
SELECT xref_int_value
INTO l_int_val
FROM ecx_xref_standards
WHERE standard_id = l_univ_std_id
AND xref_category_id = p_category_id
AND xref_std_value = rtrim(p_value);
SELECT xref_ext_value
INTO l_ext_val
FROM ecx_xref_dtl
WHERE tp_header_id = p_rec_tp_id AND
standard_id = l_standard_id AND
xref_category_id = p_category_id AND
xref_int_value = l_int_val AND
direction = 'OUT';
SELECT xref_std_value
INTO l_ext_val
FROM ecx_xref_standards
WHERE standard_id = p_standard_id
AND xref_category_id = p_category_id
AND xref_int_value = p_value;
SELECT xref_std_value
INTO l_ext_val
FROM ecx_xref_standards
WHERE standard_id = l_univ_std_id
AND xref_category_id = p_category_id
AND xref_int_value = p_value;