DBA Data[Home] [Help]

APPS.BEN_ENROLMENT_REQUIREMENTS dependencies on BEN_LER_BNFT_RSTRN_F

Line 3319: FROM ben_oipl_f oipl, ben_ler_bnft_rstrn_f lbr, ben_plip_f plip

3315: plip.bnft_or_option_rstrctn_cd,
3316: lbr.cvg_incr_r_decr_only_cd,
3317: lbr.mx_cvg_mlt_incr_num,
3318: lbr.mx_cvg_mlt_incr_wcf_num
3319: FROM ben_oipl_f oipl, ben_ler_bnft_rstrn_f lbr, ben_plip_f plip
3320: WHERE plip.plip_id = l_plip_id
3321: AND plip.business_group_id = p_business_group_id
3322: AND plip.bnft_or_option_rstrctn_cd = 'OPT'
3323: AND l_lf_evt_ocrd_dt BETWEEN plip.effective_start_date

Line 3343: FROM ben_oipl_f oipl, ben_ler_bnft_rstrn_f lbr, ben_pl_f pl

3339: pl.bnft_or_option_rstrctn_cd,
3340: lbr.cvg_incr_r_decr_only_cd,
3341: lbr.mx_cvg_mlt_incr_num,
3342: lbr.mx_cvg_mlt_incr_wcf_num
3343: FROM ben_oipl_f oipl, ben_ler_bnft_rstrn_f lbr, ben_pl_f pl
3344: WHERE pl.pl_id = l_pl_id
3345: AND pl.business_group_id = p_business_group_id
3346: AND l_lf_evt_ocrd_dt BETWEEN pl.effective_start_date
3347: AND pl.effective_end_date