[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
dpnt.elig_cvrd_dpnt_id elig_cvrd_dpnt_id,
enrt.prtt_enrt_rslt_id prtt_enrt_rslt_id,
enrt.pl_id pl_id,
enrt.oipl_id oipl_id,
enrt.orgnl_enrt_dt orgn_strdt,
dpnt.cvg_strt_dt cvg_strt_dt,
dpnt.cvg_thru_dt cvg_thru_dt,
enrt.bnft_amt bnft_amt,
enrt.pgm_id pgm_id,
enrt.bnft_ordr_num bnft_order_num,
enrt.enrt_mthd_cd mthd_cd,
enrt.enrt_ovridn_flag ovridn_flag,
enrt.enrt_ovrid_thru_dt ovrid_thru_dt,
enrt.enrt_ovrid_rsn_cd ovrid_rsn_cd,
enrt.sspndd_flag sspndd_flag,
enrt.effective_start_date effct_strdt,
enrt.last_update_date,
enrt.prtt_enrt_rslt_stat_cd,
enrt.per_in_ler_id,
enrt.pen_attribute1,
enrt.pen_attribute2,
enrt.pen_attribute3,
enrt.pen_attribute4,
enrt.pen_attribute5,
enrt.pen_attribute6,
enrt.pen_attribute7,
enrt.pen_attribute8,
enrt.pen_attribute9,
enrt.pen_attribute10,
pl.pl_typ_id pl_typ_id,
pl.name pl_name,
pl.pln_attribute1,
pl.pln_attribute2,
pl.pln_attribute3,
pl.pln_attribute4,
pl.pln_attribute5,
pl.pln_attribute6,
pl.pln_attribute7,
pl.pln_attribute8,
pl.pln_attribute9,
pl.pln_attribute10,
ptp.name pl_typ_name,
ptp.ptp_attribute1,
ptp.ptp_attribute2,
ptp.ptp_attribute3,
ptp.ptp_attribute4,
ptp.ptp_attribute5,
ptp.ptp_attribute6,
ptp.ptp_attribute7,
ptp.ptp_attribute8,
ptp.ptp_attribute9,
ptp.ptp_attribute10,
pil.per_in_ler_stat_cd,
pil.lf_evt_ocrd_dt,
pil.ntfn_dt,
pil.ler_id,
ler.name ler_name
from
ben_elig_cvrd_dpnt_f dpnt,
ben_prtt_enrt_rslt_f enrt,
ben_pl_f pl,
ben_pl_typ_f ptp,
ben_per_in_ler pil,
ben_ler_f ler
Where
dpnt.dpnt_person_id = p_dpnt_person_id
and enrt.person_id = p_prtt_person_id
and enrt.prtt_enrt_rslt_id = dpnt.prtt_enrt_rslt_id
and p_effective_date between enrt.effective_start_date
and enrt.effective_end_date
and p_effective_date between dpnt.effective_start_date
and dpnt.effective_end_date
and enrt.pl_id = pl.pl_id
and pl.invk_flx_cr_pl_flag = 'N'
and pl.imptd_incm_calc_cd is null
and pl.invk_dcln_prtn_pl_flag = 'N'
and p_effective_date between pl.effective_start_date
and pl.effective_end_date
and pl.pl_typ_id = ptp.pl_typ_id
and p_effective_date between ptp.effective_start_date
and ptp.effective_end_date
and pil.per_in_ler_id=dpnt.per_in_ler_id
and pil.ler_id = ler.ler_id
and p_effective_date between ler.effective_start_date
and ler.effective_end_date
;
select
pgm.name pgm_name,
pgm.pgm_attribute1,
pgm.pgm_attribute2,
pgm.pgm_attribute3,
pgm.pgm_attribute4,
pgm.pgm_attribute5,
pgm.pgm_attribute6,
pgm.pgm_attribute7,
pgm.pgm_attribute8,
pgm.pgm_attribute9,
pgm.pgm_attribute10
from ben_pgm_f pgm
where p_pgm_id = pgm.pgm_id
and p_effective_date between pgm.effective_start_date
and pgm.effective_end_date ;
select cpp.cpp_attribute1,
cpp.cpp_attribute2,
cpp.cpp_attribute3,
cpp.cpp_attribute4,
cpp.cpp_attribute5,
cpp.cpp_attribute6,
cpp.cpp_attribute7,
cpp.cpp_attribute8,
cpp.cpp_attribute9,
cpp.cpp_attribute10
from ben_plip_f cpp
where p_pl_id = cpp.pl_id
and p_pgm_id = cpp.pgm_id
and p_effective_date between cpp.effective_start_date
and cpp.effective_end_date
;
select
opt.opt_id opt_id,
opt.name opt_name,
oipl.cop_attribute1,
oipl.cop_attribute2,
oipl.cop_attribute3,
oipl.cop_attribute4,
oipl.cop_attribute5,
oipl.cop_attribute6,
oipl.cop_attribute7,
oipl.cop_attribute8,
oipl.cop_attribute9,
oipl.cop_attribute10
from
ben_oipl_f oipl,
ben_opt_f opt
where p_oipl_id = oipl.oipl_id
and p_effective_date between oipl.effective_start_date
and oipl.effective_end_date
and opt.opt_id = oipl.opt_id
and p_effective_date between opt.effective_start_date
and opt.effective_end_date
;
select ppl.plcy_r_grp
from ben_popl_org_f ppl,
per_all_assignments_f asg
where pl_id = l_pl_id
and plcy_r_grp is not null
and asg.assignment_id = l_asg_id
and ppl.organization_id = asg.organization_id
and p_effective_date between ppl.effective_start_date
and ppl.effective_end_date
and p_effective_date between asg.effective_start_date
and asg.effective_end_date ;
SELECT name
,ext_ident
,prmry_care_prvdr_typ_cd
,effective_start_date
,effective_end_date
FROM ben_prmry_care_prvdr_f ppr
WHERE ppr.elig_cvrd_dpnt_id = p_elig_cvrd_dpnt_id
AND p_effective_date between ppr.effective_start_date
and ppr.effective_end_date;
select assignment_id
from per_all_assignments_f asg
where person_id = p_prtt_person_id
and p_effective_date between asg.effective_start_date
and asg.effective_end_date
and asg.primary_flag = 'Y' ;
p_last_update_date => dpnt_enrt.last_update_date,
p_ler_id => dpnt_enrt.ler_id,
p_ntfn_dt => dpnt_enrt.ntfn_dt,
p_lf_evt_ocrd_dt => dpnt_enrt.lf_evt_ocrd_dt,
p_per_in_ler_stat_cd => dpnt_enrt.per_in_ler_stat_cd,
p_per_in_ler_id => dpnt_enrt.per_in_ler_id,
p_prtt_enrt_rslt_id => dpnt_enrt.prtt_enrt_rslt_id,
p_effective_date => p_effective_date,
p_include => l_include
);