[Home] [Help]
33: select prv.rt_val , prv.tx_typ_cd,prv.acty_typ_cd
34: from ben_prtt_enrt_rslt_f pen,
35: ben_prtt_rt_val prv,
36: ben_acty_base_rt_f abr,
37: ben_pl_f pln,
38: ben_per_in_ler pil
39: where pen.person_id = p_person_id
40: and pen.prtt_enrt_rslt_stat_cd is null
41: and pen.enrt_cvg_thru_dt = p_eot
65: --
66: cursor c_ben_amt(p_highly_comp in varchar2,p_eot in date) is
67: select sum(pen.bnft_amt)
68: from ben_prtt_enrt_rslt_f pen,
69: ben_pl_f pln,
70: ben_per_in_ler pil
71: where pen.person_id = p_person_id
72: and pen.prtt_enrt_rslt_stat_cd is null
73: and pen.enrt_cvg_thru_dt = p_eot
125: --
126: cursor c_imp_inc_plan is
127: select pln.pl_id,
128: pln.pl_cd
129: from ben_pl_f pln
130: where pln.imptd_incm_calc_cd = p_imptd_incm_calc_cd
131: and pln.pl_stat_cd = 'A'
132: and pln.business_group_id = p_business_group_id
133: and p_effective_date
157: pen.pl_id,
158: pen.oipl_id,
159: pen.pgm_id,
160: pen.pl_typ_id
161: from ben_pl_f pln,
162: ben_prtt_enrt_rslt_f pen
163: where pln.imptd_incm_calc_cd = p_imptd_incm_calc_cd
164: and pln.pl_stat_cd = 'A'
165: and p_effective_date
211: --
212: cursor c_pgm_enrt_rslt_exists(p_pgm_id in number) is
213: select null
214: from ben_prtt_enrt_rslt_f pen,
215: ben_pl_f pln
216: where pen.business_group_id = p_business_group_id
217: and pen.prtt_enrt_rslt_stat_cd is null
218: and pen.pgm_id = p_pgm_id
219: and pen.person_id = p_person_id
990: --
991: /*
992: cursor c_imp_plan_exists is
993: select 'Y'
994: from ben_pl_f pln
995: where pln.imptd_incm_calc_cd is not null
996: and pln.pl_stat_cd = 'A'
997: and pln.business_group_id = p_business_group_id
998: and p_effective_date
1004: -- exist for the per_in_ler do not do the imputed income computation.
1005: --
1006: cursor c_imp_plan_exists is
1007: select 'Y'
1008: from ben_pl_f pln,
1009: ben_elig_per_elctbl_chc epe
1010: where pln.subj_to_imptd_incm_typ_cd is not null
1011: and pln.pl_id = epe.pl_id
1012: and epe.per_in_ler_id = p_per_in_ler_id