The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT /*+ benpepch.get_pilplnpep_dets.c_current_elig_for_plan */
pep.elig_per_id,
pep.elig_flag,
pep.must_enrl_anthr_pl_id,
pep.prtn_strt_dt,
pep.inelg_rsn_cd
FROM ben_elig_per_f pep,
ben_per_in_ler pil
WHERE pep.per_in_ler_id = c_per_in_ler_id
AND pep.pl_id = c_pl_id
AND pep.pgm_id = c_pgm_id
AND c_effective_date
BETWEEN pep.effective_start_date AND pep.effective_end_date
AND pil.per_in_ler_id (+) = pep.per_in_ler_id
AND pil.business_group_id (+) = pep.business_group_id
AND (
pil.per_in_ler_stat_cd NOT IN
(
'VOIDD',
'BCKDT')
OR pil.per_in_ler_stat_cd IS NULL);
SELECT /*+ benpepch.get_pilplnpep_dets.c_current_elig_for_plnip */
pep.elig_per_id,
pep.elig_flag,
pep.must_enrl_anthr_pl_id,
pep.prtn_strt_dt,
pep.inelg_rsn_cd
FROM ben_elig_per_f pep,
ben_per_in_ler pil
WHERE pep.per_in_ler_id = c_per_in_ler_id
AND pep.pl_id = c_pl_id
AND pep.pgm_id IS NULL
AND c_effective_date
BETWEEN pep.effective_start_date AND pep.effective_end_date
AND pil.per_in_ler_id (+) = pep.per_in_ler_id
AND pil.business_group_id (+) = pep.business_group_id
AND (
pil.per_in_ler_stat_cd NOT IN
(
'VOIDD',
'BCKDT')
OR pil.per_in_ler_stat_cd IS NULL);
SELECT /*+ benpepch.get_pilplnpep_dets.c_current_elig_for_option */
ep.elig_per_id,
epo.elig_flag,
ep.must_enrl_anthr_pl_id,
epo.prtn_strt_dt,
epo.inelg_rsn_cd
FROM ben_elig_per_f ep,
ben_elig_per_opt_f epo,
ben_per_in_ler pil
WHERE ep.per_in_ler_id = c_per_in_ler_id
AND ep.pl_id = c_pl_id
AND ep.pgm_id = c_pgm_id
AND c_effective_date
BETWEEN ep.effective_start_date AND ep.effective_end_date
AND ep.elig_per_id = epo.elig_per_id
AND epo.opt_id = c_opt_id
AND c_effective_date
BETWEEN epo.effective_start_date AND epo.effective_end_date
AND pil.per_in_ler_id (+) = epo.per_in_ler_id
AND pil.business_group_id (+) = epo.business_group_id
AND (
pil.per_in_ler_stat_cd NOT IN
(
'VOIDD',
'BCKDT')
OR pil.per_in_ler_stat_cd IS NULL);
SELECT /*+ benpepch.get_pilplnpep_dets.c_current_elig_for_optnip */
ep.elig_per_id,
epo.elig_flag,
ep.must_enrl_anthr_pl_id,
epo.prtn_strt_dt,
epo.inelg_rsn_cd
FROM ben_elig_per_f ep,
ben_elig_per_opt_f epo,
ben_per_in_ler pil
WHERE ep.per_in_ler_id = c_per_in_ler_id
AND ep.pl_id = c_pl_id
AND ep.pgm_id IS NULL
AND c_effective_date
BETWEEN ep.effective_start_date AND ep.effective_end_date
AND ep.elig_per_id = epo.elig_per_id
AND epo.opt_id = c_opt_id
AND c_effective_date
BETWEEN epo.effective_start_date AND epo.effective_end_date
AND pil.per_in_ler_id (+) = epo.per_in_ler_id
AND pil.business_group_id (+) = epo.business_group_id
AND (
pil.per_in_ler_stat_cd NOT IN
(
'VOIDD',
'BCKDT')
OR pil.per_in_ler_stat_cd IS NULL);
select /*+ benpepch.get_curroiplippep_dets.c_oiplip_dets */
pep.elig_per_id
from ben_elig_per_f pep,
ben_per_in_ler pil
where pep.person_id = c_person_id
and pep.pgm_id = c_pgm_id
and pep.plip_id = c_plip_id
and c_effective_date
between pep.effective_start_date
and pep.effective_end_date
and pil.per_in_ler_id(+)=pep.per_in_ler_id
and pil.business_group_id(+)=pep.business_group_id
and ( pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT')
or pil.per_in_ler_stat_cd is null);
select /*+ benpepch.get_curroiplippep_dets.c_oiplipnip_dets */
pep.elig_per_id
from ben_elig_per_f pep,
ben_per_in_ler pil
where pep.person_id = c_person_id
and pep.pgm_id is null
and pep.plip_id = c_plip_id
and c_effective_date
between pep.effective_start_date
and pep.effective_end_date
and pil.per_in_ler_id(+)=pep.per_in_ler_id
and pil.business_group_id(+)=pep.business_group_id
and ( pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT')
or pil.per_in_ler_stat_cd is null);
select /*+ benpepch.get_currplnpep_dets.c_pln_dets */
pep.elig_per_id,
pep.prtn_strt_dt,
pep.prtn_end_dt
from ben_elig_per_f pep,
ben_per_in_ler pil
where pep.person_id = c_person_id
and pep.pgm_id = c_pgm_id
and pep.pl_id = c_pl_id
and c_effective_date
between pep.effective_start_date
and pep.effective_end_date
and pil.per_in_ler_id(+)=pep.per_in_ler_id
and pil.business_group_id(+)=pep.business_group_id
and ( pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT')
or pil.per_in_ler_stat_cd is null);
select /*+ benpepch.get_currplnpep_dets.c_plnip_dets */
pep.elig_per_id,
pep.prtn_strt_dt,
pep.prtn_end_dt
from ben_elig_per_f pep,
ben_per_in_ler pil
where pep.person_id = c_person_id
and pep.pgm_id is null
and pep.pl_id = c_pl_id
and c_effective_date
between pep.effective_start_date
and pep.effective_end_date
and pil.per_in_ler_id(+)=pep.per_in_ler_id
and pil.business_group_id(+)=pep.business_group_id
and ( pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT')
or pil.per_in_ler_stat_cd is null);
g_pilpep_lookup.delete;
g_pilpep_instance.delete;
g_optpilepo_lookup.delete;
g_optpilepo_instance.delete;