The following lines contain the word 'select', 'insert', 'update' or 'delete':
select pbg.security_group_id,
pbg.legislation_code
from per_business_groups_perf pbg
, per_comp_element_outcomes ceo
where ceo.comp_element_outcome_id = p_comp_element_outcome_id;
select pbg.legislation_code
from per_business_groups_perf pbg
, per_comp_element_outcomes ceo
where ceo.comp_element_outcome_id = p_comp_element_outcome_id;
Procedure chk_non_updateable_args
(p_effective_date in date
,p_rec in per_ceo_shd.g_rec_type
) IS
--
l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
End chk_non_updateable_args;
select 'x' from per_competence_elements
where competence_element_id = p_competence_element_id;
select 'x' from per_competence_outcomes
where outcome_id = p_outcome_id;
select 'x' from per_comp_element_outcomes o
where o.competence_element_id = p_competence_element_id
and o.outcome_id = p_outcome_id
and p_date_from < nvl(o.date_to,hr_api.g_eot)
and nvl(p_date_to,hr_api.g_eot) > o.date_from;
select 'x' from per_comp_element_outcomes o
where o.comp_element_outcome_id = p_comp_element_outcome_id
and o.competence_element_id = p_competence_element_id
and o.outcome_id = p_outcome_id
and p_date_from < nvl(o.date_to,hr_api.g_eot)
and nvl(p_date_to,hr_api.g_eot) > o.date_from;*/
select 'x' from per_comp_element_outcomes o,per_competence_outcomes co
where o.comp_element_outcome_id <> p_comp_element_outcome_id
and o.competence_element_id = p_competence_element_id
and co.outcome_id = o.outcome_id
and co.name = p_name
and(p_date_from between o.date_from and nvl(o.date_to,hr_api.g_eot)
or p_date_to between o.date_from and nvl(o.date_to,hr_api.g_eot)
or o.date_from between p_date_from and p_date_to );
select name
into l_outcome_name
from per_competence_outcomes
where outcome_id = p_outcome_id;
select date_from from per_competence_outcomes cpo
where cpo.outcome_id = p_outcome_id ;
Procedure insert_validate
(p_effective_date in date
,p_rec in per_ceo_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_ceo_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_ceo_shd.g_rec_type
) is
--
l_proc varchar2(72) := g_package||'delete_validate';
End delete_validate;
select count(cpo.outcome_id) from per_competence_outcomes cpo
where cpo.competence_id = p_competence_id
and p_effective_date between date_from
and nvl(date_to,hr_api.g_eot);
select count(ceo.comp_element_outcome_id)
,max(ceo.date_from)
from per_comp_element_outcomes ceo
where ceo.competence_element_id = p_competence_element_id
-- and p_effective_date between ceo.date_from
-- and nvl(date_to,hr_api.g_eot)
and ceo.outcome_id in (
select cpo2.outcome_id from per_competence_outcomes cpo2
where cpo2.competence_id = p_competence_id
and p_effective_date between cpo2.date_from
and nvl(cpo2.date_to,hr_api.g_eot));