The following lines contain the word 'select', 'insert', 'update' or 'delete':
select 1
into x_temp
from JTF_PERZ_PROFILE profile,
JTF_PERZ_DATA data,
JTF_PERZ_DATA_ATTRIB attrib
where profile.profile_name = x_profile_name
and profile.profile_id = data.profile_id
and data.application_id = 170
and data.perz_data_name = 'CS_KB_WF_CATEGORY'
and data.perz_data_id = attrib.perz_data_id
and attrib.attribute_name = to_char(m_category_id);
select 1
into x_temp
from JTF_PERZ_PROFILE profile,
JTF_PERZ_DATA data,
JTF_PERZ_DATA_ATTRIB attrib
where profile.profile_name = x_profile_name
and profile.profile_id = data.profile_id
and data.application_id = 170
and data.perz_data_name = 'CS_KB_WF_PRODUCT'
and data.perz_data_id = attrib.perz_data_id
and attrib.attribute_name = to_char(m_product_id)
and decode(substr(attrib.attribute_value,1,4),
'org_', to_number(replace(attrib.attribute_value, 'org_','')) ,
cs_std.get_item_valdn_orgzn_id) = m_product_org_id;