[Home] [Help]
19: bpl.business_group_id, bpl.effective_start_date, bpl.effective_end_date,
20: bpl.object_version_number, bpl.per_in_ler_id,
21: bpl.frftd_val, bpl.used_val, bpl.prvdd_val, bpl.cash_recd_val, bpl.rld_up_val
22: from ben_bnft_prvdd_ldgr_f bpl,
23: ben_per_in_ler pil,
24: ben_prtt_enrt_rslt_f pen
25: where (bpl.acty_ref_perd_cd is null or
26: (bpl.used_val is not null and bpl.cmcd_used_val is null))
27: and bpl.per_in_ler_id = pil.per_in_ler_id
267: c_enrt_info_rt_freq_cd in varchar2,
268: c_effective_date in date,
269: c_prvdd_val in number)is
270: select distinct ann_val, cmcd_val
271: from ben_enrt_rt ecr, ben_elig_per_elctbl_chc epe, ben_per_in_ler pil,
272: ben_pil_elctbl_chc_popl pel
273: where ecr.acty_base_rt_id = c_acty_base_rt_id
274: -- make sure we're dealing with the exact same rate
275: and ecr.val = c_prvdd_val
291: c_acty_ref_perd_cd in varchar2,
292: c_enrt_info_rt_freq_cd in varchar2,
293: c_effective_date in date)is
294: select distinct epe.elig_per_elctbl_chc_id, ecr.enrt_rt_id, pil.lf_evt_ocrd_dt
295: from ben_enrt_rt ecr, ben_elig_per_elctbl_chc epe, ben_per_in_ler pil,
296: ben_pil_elctbl_chc_popl pel, ben_enrt_bnft enb
297: where ecr.acty_base_rt_id = c_acty_base_rt_id
298: -- make sure we're dealing with the exact same rate
299: and pel.acty_ref_perd_cd = c_acty_ref_perd_cd
314: cursor get_flex_shell_rt(c_per_in_ler_id in number,
315: c_pgm_id in number) is
316: select ecr.enrt_rt_id, abr.acty_base_rt_id, abr.element_type_id,
317: epe.elig_per_elctbl_chc_id , pil.lf_evt_ocrd_dt
318: from ben_enrt_rt ecr, ben_elig_per_elctbl_chc epe, ben_per_in_ler pil,
319: ben_acty_base_rt_f abr
320: where epe.elig_per_elctbl_chc_id = ecr.elig_per_elctbl_chc_id
321: and epe.pgm_id = c_pgm_id
322: and epe.comp_lvl_cd = 'PLANFC'