The following lines contain the word 'select', 'insert', 'update' or 'delete':
Select meaning into l_node_label
from fnd_lookup_values_vl
where lookup_type = 'IEU_NODE_LABELS'
and view_application_id = 696
and lookup_code = 'IEU_WORKLIST_LBL';
Select meaning into l_node_label
from fnd_lookup_values_vl
where lookup_type = 'IEU_NODE_LABELS'
and view_application_id = 696
and lookup_code = 'IEU_MY_OWN_LBL';
Select meaning into l_node_label
from fnd_lookup_values_vl
where lookup_type = 'IEU_NODE_LABELS'
and view_application_id = 696
and lookup_code = 'IEU_MY_ASSIGN_LBL';
Select meaning into l_node_label
from fnd_lookup_values_vl
where lookup_type = 'IEU_NODE_LABELS'
and view_application_id = 696
and lookup_code = 'IEU_GRP_OWN_LBL';
( select group_id from jtf_rs_group_members where resource_id= :owner_id ) and (status_id <> 3 or status_id <> 4) ';
Select meaning into l_node_label
from fnd_lookup_values_vl
where lookup_type = 'IEU_NODE_LABELS'
and view_application_id = 696
and lookup_code = 'IEU_GRP_ASSIGN_LBL';
( select group_id from jtf_rs_group_members where resource_id= :assignee_id ) and (status_id <> 3 or status_id <> 4) ';
select node_type
into l_node_type
from ieu_uwq_sel_rt_nodes
where resource_id=P_RESOURCE_ID
and node_id=P_NODE_ID;
select count(*)
into x_count
from ieu_uwqm_items where
(((owner_id in (select group_id from jtf_rs_group_members where
resource_id=p_resource_id ) and owner_type=l_owner_type_grp)
OR (owner_id=p_resource_id AND owner_type = l_owner_type_ind))
OR
((assignee_id in (select group_id from jtf_rs_group_members where
resource_id=p_resource_id ) and assignee_type=l_owner_type_grp)
OR (assignee_id=p_resource_id AND assignee_type = l_owner_type_ind)))
and status_id not in (3,4);
select count(*)
into x_ind_own_count
-- from IEU_UWQ_WORKLIST_V
from ieu_uwqm_items
where owner_type = 'RS_INDIVIDUAL'
and owner_id = p_resource_id
and (status_id <> 3 or status_id <> 4);
select count(*)
into x_grp_own_count
from ieu_uwqm_items
where owner_type ='RS_GROUP'
and owner_id in
(
select group_id from jtf_rs_group_members
where resource_id= p_resource_id
)
and (status_id <> 3 or status_id <> 4);
select count(*)
into x_ind_asg_count
from ieu_uwqm_items
where assignee_type ='RS_INDIVIDUAL'
and assignee_id = p_resource_id
and (status_id <> 3 or status_id <> 4);
select count(*)
into x_grp_asg_count
from ieu_uwqm_items
where
assignee_type = 'RS_GROUP'
and assignee_id in
(
select group_id from jtf_rs_group_members
where resource_id= p_resource_id
)
and (status_id <> 3 or status_id <> 4);