APPS.BEN_ENROLLMENT_PROCESS dependencies on BEN_ENRT_RT

Line 733: from ben_enrt_rt ecr

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

Line 752: from ben_enrt_rt ecr

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

Line 759: from ben_enrt_rt ecr

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

Line 765: from ben_enrt_rt ecr

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