DBA Data[Home] [Help]

APPS.BEN_ENROLLMENT_PROCESS dependencies on BEN_ENRT_BNFT

Line 706: from ben_enrt_bnft enb

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

Line 720: from ben_enrt_bnft enb

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