The following lines contain the word 'select', 'insert', 'update' or 'delete':
select null
from pqh_routing_lists a
where a.routing_list_id = p_routing_list_id;
select null
from pqh_roles a
where a.role_id = p_role_id;
select null
from pqh_role_users_v
where user_id = nvl(p_user_id, -1)
and role_id = p_role_id;
select null
from pqh_routing_list_members a
where a.routing_list_id=p_routing_list_id
and a.role_id = p_role_id
and nvl(a.user_id,-1) = nvl(p_user_id, -1);
select null
from pqh_routing_list_members a
where a.routing_list_id=p_routing_list_id
and a.seq_no = p_seq_no;
select enable_flag
from pqh_routing_lists
where routing_list_id = p_routing_list_id;
select enable_flag
from pqh_roles
where role_id = p_role_id;
select 'x'
from pqh_role_users_v
where role_id = p_role_id
and user_id = p_user_id;
select distinct ptc.transaction_category_id, ptc.name transaction_category_name,
ptc.business_group_id
from pqh_routing_list_members rlm, pqh_routing_categories rct,
pqh_transaction_categories ptc
where rlm.routing_list_id = rct.routing_list_id
and rct.routing_list_id = p_routing_list_id
and rct.transaction_category_id = ptc.transaction_category_id;
select freeze_status_cd
from pqh_transaction_categories_vl
where transaction_category_id = p_transaction_category_id;
select distinct rtc.transaction_category_id
from pqh_attribute_ranges arg, pqh_routing_categories rtc
where routing_list_member_id = p_routing_list_member_id
and arg.routing_category_id = rtc.routing_category_id;
Procedure insert_validate(p_rec in pqh_rlm_shd.g_rec_type
,p_effective_date in date) is
--
l_proc varchar2(72) := g_package||'insert_validate';
End insert_validate;
Procedure update_validate(p_rec in pqh_rlm_shd.g_rec_type
,p_effective_date in date) is
--
l_proc varchar2(72) := g_package||'update_validate';
End update_validate;
Procedure delete_validate(p_rec in pqh_rlm_shd.g_rec_type
,p_effective_date in date) is
--
l_proc varchar2(72) := g_package||'delete_validate';
End delete_validate;