APPS.BEN_ENROLLMENT_PROCESS dependencies on BEN_ENRT_RT

Line 730: from ben_enrt_rt ecr

726: rt_strt_dt_cd,
727: entr_val_at_enrt_flag,
728: val,
729: ann_val
730: from ben_enrt_rt ecr
731: where ecr.elig_per_elctbl_chc_id = l_epe.elig_per_elctbl_chc_id
732: --and ecr.entr_val_at_enrt_flag = 'Y'
733: and ecr.acty_base_rt_id = p_acty_base_rt_id ;
734: --

Line 749: from ben_enrt_rt ecr

745: rt_strt_dt_cd,
746: entr_val_at_enrt_flag,
747: val,
748: ann_val
749: from ben_enrt_rt ecr
750: where ecr.enrt_bnft_id = l_enb.enrt_bnft_id
751: --and ecr.entr_val_at_enrt_flag = 'Y'
752: and ecr.acty_base_rt_id = p_acty_base_rt_id ;
753: --

Line 756: from ben_enrt_rt ecr

752: and ecr.acty_base_rt_id = p_acty_base_rt_id ;
753: --
754: cursor c_ecr_eve(p_epe_id number) is
755: select 'Y'
756: from ben_enrt_rt ecr
757: where ecr.elig_per_elctbl_chc_id = p_epe_id
758: and ecr.entr_val_at_enrt_flag = 'Y' ;
759: --
760: cursor c_ecr_enb_eve(p_enb_id number) is

Line 762: from ben_enrt_rt ecr

758: and ecr.entr_val_at_enrt_flag = 'Y' ;
759: --
760: cursor c_ecr_enb_eve(p_enb_id number) is
761: select 'Y'
762: from ben_enrt_rt ecr
763: where ecr.enrt_bnft_id = p_enb_id
764: and ecr.entr_val_at_enrt_flag = 'Y' ;
765: --
766: l_dummy varchar2(30);