[Home] [Help]
318: where epe.per_in_ler_id = l_per_in_ler_id
319: and epe.pil_elctbl_chc_popl_id = pel.pil_elctbl_chc_popl_id
320: and epe.per_in_ler_id = pel.per_in_ler_id
321: and epe.comp_lvl_cd not in ('PLANFC', 'PLANIMP')
322: and (exists (select null from ben_enrt_rt ecr
323: where ecr.elig_per_elctbl_chc_id = epe.elig_per_elctbl_chc_id
324: and ecr.rt_mlt_cd = 'ERL') or exists (
325: select null from ben_enrt_rt ecr, ben_enrt_bnft enb
326: where enb.elig_per_elctbl_chc_id = epe.elig_per_elctbl_chc_id
321: and epe.comp_lvl_cd not in ('PLANFC', 'PLANIMP')
322: and (exists (select null from ben_enrt_rt ecr
323: where ecr.elig_per_elctbl_chc_id = epe.elig_per_elctbl_chc_id
324: and ecr.rt_mlt_cd = 'ERL') or exists (
325: select null from ben_enrt_rt ecr, ben_enrt_bnft enb
326: where enb.elig_per_elctbl_chc_id = epe.elig_per_elctbl_chc_id
327: and ecr.enrt_bnft_id = enb.enrt_bnft_id
328: and ecr.rt_mlt_cd = 'ERL'));
329:
458: ecr.rt_strt_dt,
459: ecr.ENTR_VAL_AT_ENRT_FLAG,
460: ecr.rt_mlt_cd,
461: nvl(ecr.cmcd_val,ecr.cmcd_dflt_val) cmcd_val /* bug 7414466 */
462: from ben_enrt_rt ecr
463: where ecr.elig_per_elctbl_chc_id = v_elig_per_elctbl_chc_id
464: and ecr.business_group_id = p_business_group_id
465: -- added for canon fix
466: and ecr.rt_mlt_cd <> 'ERL'
476: ecr.rt_strt_dt,
477: ecr.ENTR_VAL_AT_ENRT_FLAG,
478: ecr.rt_mlt_cd,
479: nvl(ecr.cmcd_val,ecr.cmcd_dflt_val) cmcd_val /* bug 7414466 */
480: from ben_enrt_rt ecr
481: where ecr.enrt_bnft_id = v_enrt_bnft_id
482: and ecr.business_group_id = p_business_group_id
483: -- added for canon fix
484: and ecr.rt_mlt_cd <> 'ERL'
520: ecr.acty_typ_cd,
521: ecr.tx_typ_cd,
522: ecr.rt_strt_dt_cd,
523: ecr.rt_strt_dt
524: from ben_enrt_rt ecr
525: where ecr.elig_per_elctbl_chc_id = v_elig_per_elctbl_chc_id
526: and ecr.business_group_id = p_business_group_id
527: -- added for canon fix
528: and ecr.rt_mlt_cd = 'ERL'
535: ecr.acty_typ_cd,
536: ecr.tx_typ_cd,
537: ecr.rt_strt_dt_cd,
538: ecr.rt_strt_dt
539: from ben_enrt_rt ecr
540: where ecr.enrt_bnft_id = v_enrt_bnft_id
541: and ecr.business_group_id = p_business_group_id
542: -- added for canon fix
543: and ecr.rt_mlt_cd = 'ERL'
702: ecr.acty_base_rt_id,
703: nvl(ecr.dflt_val, ecr.val) val
704: from ben_elig_per_elctbl_chc epe1,
705: ben_elig_per_elctbl_chc epe,
706: ben_enrt_rt ecr
707: where epe1.elig_per_elctbl_chc_id=l_epe.elig_per_elctbl_chc_id and
708: epe1.business_group_id=p_business_group_id and
709: epe1.pgm_id = epe.pgm_id and
710: epe1.per_in_ler_id = epe.per_in_ler_id and
2407: --
2408: cursor c_ecr is
2409: select
2410: ecr.*
2411: from ben_enrt_rt ecr
2412: where ecr.enrt_rt_id = p_enrt_rt_id and
2413: ecr.business_group_id = p_business_group_id ;
2414: --
2415: cursor c_abr is
2454: ,p_object_version_number => l_prv.object_version_number
2455: ,p_effective_date => p_effective_date
2456: );
2457: --
2458: update ben_enrt_rt ecr
2459: set prtt_rt_val_id = null
2460: where enrt_rt_id = p_enrt_rt_id ;
2461: --
2462: elsif l_prv.rt_strt_dt < p_rt_strt_dt and p_mode = 'NEW' then
2491: --
2492: elsif l_delete then -- if l_prv_future.rt_val <> p_rt_val then
2493: --
2494: /*
2495: update ben_enrt_rt ecr
2496: set prtt_rt_val_id = null -- l_prv_future.prtt_rt_val_id
2497: where enrt_rt_id = p_enrt_rt_id ;
2498: */
2499: if l_abr.processing_type = 'N' or
2579: end loop;
2580: --
2581: if l_delete then
2582: --
2583: update ben_enrt_rt ecr
2584: set prtt_rt_val_id = null -- l_prv_future.prtt_rt_val_id
2585: where enrt_rt_id = p_enrt_rt_id ;
2586: --
2587: end if;
2654: cursor c_new_cr_val (p_acty_base_rt_id number,
2655: p_bnft_prvdr_pool_id number) is
2656: select ecr.val,
2657: ecr.elig_per_elctbl_chc_id
2658: from ben_enrt_rt ecr
2659: where ecr.acty_base_rt_id = p_acty_base_rt_id
2660: and ecr.elig_per_elctbl_chc_id in
2661: (select
2662: epe.elig_per_elctbl_chc_id