DBA Data[Home] [Help]

APPS.BEN_ENROLLMENT_PROCESS dependencies on BEN_ENRT_BNFT

Line 703: from ben_enrt_bnft enb

699: enb.val,
700: enb.mn_val,
701: enb.mx_val,
702: enb.incrmt_val
703: from ben_enrt_bnft enb
704: where enb.elig_per_elctbl_chc_id = l_epe.elig_per_elctbl_chc_id
705: and enb.mx_wo_ctfn_flag = 'N'
706: and (enb.entr_val_at_enrt_flag = 'Y' OR enb.vaL = p_bnft_val) ;
707: --

Line 717: from ben_enrt_bnft enb

713: select enb.enrt_bnft_id,enb.cvg_mlt_cd,enb.entr_val_at_enrt_flag,enb.val,
714: enb.mn_val,
715: enb.mx_val,
716: enb.incrmt_val
717: from ben_enrt_bnft enb
718: where enb.elig_per_elctbl_chc_id = l_epe.elig_per_elctbl_chc_id
719: and enb.mx_wo_ctfn_flag = 'N' ;
720: --
721: --ECR from EPE