The following lines contain the word 'select', 'insert', 'update' or 'delete':
select pbg.security_group_id
from per_business_groups pbg
, per_checklist_items chk
, per_all_people_f peo
where chk.checklist_item_id = p_checklist_item_id
and chk.person_id = peo.person_id
and pbg.business_group_id = peo.business_group_id;
select pbg.legislation_code
from per_business_groups pbg
, per_checklist_items chk
, per_all_people_f peo
where chk.checklist_item_id = p_checklist_item_id
and chk.person_id = peo.person_id
and pbg.business_group_id = peo.business_group_id;
Procedure chk_non_updateable_args( p_effective_date in date
,p_rec in per_chk_shd.g_rec_type) is
--
l_proc varchar2(72) := g_package||'chk_non_updateable_args';
end chk_non_updateable_args;
SELECT person_id
FROM per_all_people_f
WHERE person_id = p_person_id;
Procedure insert_validate(p_effective_date in date,
p_rec in per_chk_shd.g_rec_type) is
--
l_proc varchar2(72) := g_package||'insert_validate';
End insert_validate;
Procedure update_validate(p_effective_date in date,
p_rec in per_chk_shd.g_rec_type) is
--
l_proc varchar2(72) := g_package||'update_validate';
chk_non_updateable_args(p_effective_date => p_effective_date,
p_rec => p_rec);
End update_validate;
Procedure delete_validate(p_rec in per_chk_shd.g_rec_type) is
--
l_proc varchar2(72) := g_package||'delete_validate';
End delete_validate;