[Home] [Help]
295: where epe.per_in_ler_id = l_per_in_ler_id
296: and epe.pil_elctbl_chc_popl_id = pel.pil_elctbl_chc_popl_id
297: and epe.per_in_ler_id = pel.per_in_ler_id
298: and epe.comp_lvl_cd not in ('PLANFC', 'PLANIMP')
299: and (exists (select null from ben_enrt_rt ecr
300: where ecr.elig_per_elctbl_chc_id = epe.elig_per_elctbl_chc_id
301: and ecr.rt_mlt_cd = 'ERL') or exists (
302: select null from ben_enrt_rt ecr, ben_enrt_bnft enb
303: where enb.elig_per_elctbl_chc_id = epe.elig_per_elctbl_chc_id
298: and epe.comp_lvl_cd not in ('PLANFC', 'PLANIMP')
299: and (exists (select null from ben_enrt_rt ecr
300: where ecr.elig_per_elctbl_chc_id = epe.elig_per_elctbl_chc_id
301: and ecr.rt_mlt_cd = 'ERL') or exists (
302: select null from ben_enrt_rt ecr, ben_enrt_bnft enb
303: where enb.elig_per_elctbl_chc_id = epe.elig_per_elctbl_chc_id
304: and ecr.enrt_bnft_id = enb.enrt_bnft_id
305: and ecr.rt_mlt_cd = 'ERL'));
306:
433: ecr.rt_strt_dt_cd,
434: ecr.rt_strt_dt,
435: ecr.ENTR_VAL_AT_ENRT_FLAG,
436: ecr.rt_mlt_cd
437: from ben_enrt_rt ecr
438: where ecr.elig_per_elctbl_chc_id = v_elig_per_elctbl_chc_id
439: and ecr.business_group_id = p_business_group_id
440: -- added for canon fix
441: and ecr.rt_mlt_cd <> 'ERL'
450: ecr.rt_strt_dt_cd,
451: ecr.rt_strt_dt,
452: ecr.ENTR_VAL_AT_ENRT_FLAG,
453: ecr.rt_mlt_cd
454: from ben_enrt_rt ecr
455: where ecr.enrt_bnft_id = v_enrt_bnft_id
456: and ecr.business_group_id = p_business_group_id
457: -- added for canon fix
458: and ecr.rt_mlt_cd <> 'ERL'
494: ecr.acty_typ_cd,
495: ecr.tx_typ_cd,
496: ecr.rt_strt_dt_cd,
497: ecr.rt_strt_dt
498: from ben_enrt_rt ecr
499: where ecr.elig_per_elctbl_chc_id = v_elig_per_elctbl_chc_id
500: and ecr.business_group_id = p_business_group_id
501: -- added for canon fix
502: and ecr.rt_mlt_cd = 'ERL'
509: ecr.acty_typ_cd,
510: ecr.tx_typ_cd,
511: ecr.rt_strt_dt_cd,
512: ecr.rt_strt_dt
513: from ben_enrt_rt ecr
514: where ecr.enrt_bnft_id = v_enrt_bnft_id
515: and ecr.business_group_id = p_business_group_id
516: -- added for canon fix
517: and ecr.rt_mlt_cd = 'ERL'
654: ecr.acty_base_rt_id,
655: nvl(ecr.dflt_val, ecr.val) val
656: from ben_elig_per_elctbl_chc epe1,
657: ben_elig_per_elctbl_chc epe,
658: ben_enrt_rt ecr
659: where epe1.elig_per_elctbl_chc_id=l_epe.elig_per_elctbl_chc_id and
660: epe1.business_group_id=p_business_group_id and
661: epe1.pgm_id = epe.pgm_id and
662: epe1.per_in_ler_id = epe.per_in_ler_id and
2224: --
2225: cursor c_ecr is
2226: select
2227: ecr.*
2228: from ben_enrt_rt ecr
2229: where ecr.enrt_rt_id = p_enrt_rt_id and
2230: ecr.business_group_id = p_business_group_id ;
2231: --
2232: cursor c_abr is
2271: ,p_object_version_number => l_prv.object_version_number
2272: ,p_effective_date => p_effective_date
2273: );
2274: --
2275: update ben_enrt_rt ecr
2276: set prtt_rt_val_id = null
2277: where enrt_rt_id = p_enrt_rt_id ;
2278: --
2279: elsif l_prv.rt_strt_dt < p_rt_strt_dt and p_mode = 'NEW' then
2308: --
2309: elsif l_delete then -- if l_prv_future.rt_val <> p_rt_val then
2310: --
2311: /*
2312: update ben_enrt_rt ecr
2313: set prtt_rt_val_id = null -- l_prv_future.prtt_rt_val_id
2314: where enrt_rt_id = p_enrt_rt_id ;
2315: */
2316: if l_abr.processing_type = 'N' or
2396: end loop;
2397: --
2398: if l_delete then
2399: --
2400: update ben_enrt_rt ecr
2401: set prtt_rt_val_id = null -- l_prv_future.prtt_rt_val_id
2402: where enrt_rt_id = p_enrt_rt_id ;
2403: --
2404: end if;
2471: cursor c_new_cr_val (p_acty_base_rt_id number,
2472: p_bnft_prvdr_pool_id number) is
2473: select ecr.val,
2474: ecr.elig_per_elctbl_chc_id
2475: from ben_enrt_rt ecr
2476: where ecr.acty_base_rt_id = p_acty_base_rt_id
2477: and ecr.elig_per_elctbl_chc_id in
2478: (select
2479: epe.elig_per_elctbl_chc_id