The following lines contain the word 'select', 'insert', 'update' or 'delete':
select gra.business_group_id
from per_grades gra
where gra.grade_id = p_grade_id;
select null
from per_grades gra
where gra.grade_id = p_grade_id
and p_date_from between gra.date_from
and nvl(gra.date_to, hr_api.g_eot);
select null
from per_jobs_v job
where job.job_id = p_job_id
and p_date_from >= job.date_from;
select null
from hr_positions_f pos
where pos.position_id = p_position_id
and p_date_from >= pos.date_effective
and p_effective_date between pos.effective_start_date and pos.effective_end_date;
select job.business_group_id
from per_jobs_v job
where job.job_id = p_job_id;
select null
from per_valid_grades vgr
where vgr.job_id = p_job_id
and vgr.grade_id = p_grade_id
-- Fix For Bug # 6983587 Starts
and
(
(p_date_from between vgr.date_from and nvl(vgr.date_to,hr_api.g_eot)
or
p_date_to between vgr.date_from and nvl(vgr.date_to,hr_api.g_eot)
)
or
(p_date_from < vgr.date_from and p_date_to > nvl(vgr.date_to,hr_api.g_eot))
);
select pos.business_group_id
from hr_positions_f pos
where pos.position_id = p_position_id
and p_effective_date between pos.effective_start_date and pos.effective_end_date;
select null
from per_valid_grades vgr
where vgr.position_id = p_position_id
and vgr.grade_id = p_grade_id;
select null
from per_grades gra
where gra.grade_id = p_grade_id
and nvl(p_date_to, hr_api.g_eot) between gra.date_from
and nvl(gra.date_to, hr_api.g_eot);
select null
from per_jobs_v job
where job.job_id = p_job_id
and nvl(p_date_to, hr_api.g_eot) <= nvl(job.date_to, hr_api.g_eot);
select null
from hr_positions_f pos
where pos.position_id = p_position_id
and nvl(p_date_to, hr_api.g_eot) <= nvl(hr_general.get_position_date_end(p_position_id), hr_api.g_eot)
and p_effective_date between pos.effective_start_date and pos.effective_end_date;
Procedure insert_validate(p_rec in per_vgr_shd.g_rec_type,
p_effective_date in date) is -- Added for Bug# 1760707
--
l_proc varchar2(72) := g_package||'insert_validate';
End insert_validate;
Procedure update_validate(p_rec in per_vgr_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 per_vgr_shd.g_rec_type) is
--
l_proc varchar2(72) := g_package||'delete_validate';
End delete_validate;
select pbg.legislation_code
from per_business_groups pbg
, per_valid_grades pvg
where pvg.valid_grade_id = p_valid_grade_id
and pbg.business_group_id = pvg.business_group_id;