The following lines contain the word 'select', 'insert', 'update' or 'delete':
select channel_category_id, channel_category_name bulk collect into l_cat_ids_tbl, l_cat_names_tbl
from amv_c_categories_vl
where channel_category_name like '%'
and channel_category_name not in ('AMV_GROUP', 'AMV_PRIVATE')
and application_id = 520
and parent_channel_category_id is null
order by channel_category_name;
select count(*) into l_cat_count
from amv_c_categories_vl
where channel_category_name like '%'
and channel_category_name not in ('AMV_GROUP', 'AMV_PRIVATE')
and application_id = 520
and parent_channel_category_id = p_category_id
order by channel_category_name;
select channel_category_id, channel_category_name bulk collect into l_cat_ids_tbl, l_cat_names_tbl
from amv_c_categories_vl
where channel_category_name like '%'
and channel_category_name not in ('AMV_GROUP', 'AMV_PRIVATE')
and application_id = 520
and parent_channel_category_id = p_category_id
order by channel_category_name;