DBA Data[Home] [Help]

APPS.BEN_ENROLMENT_REQUIREMENTS dependencies on BEN_LER_BNFT_RSTRN_F

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

3361: plip.bnft_or_option_rstrctn_cd,
3362: lbr.cvg_incr_r_decr_only_cd,
3363: lbr.mx_cvg_mlt_incr_num,
3364: lbr.mx_cvg_mlt_incr_wcf_num
3365: FROM ben_oipl_f oipl, ben_ler_bnft_rstrn_f lbr, ben_plip_f plip
3366: WHERE plip.plip_id = l_plip_id
3367: AND plip.business_group_id = p_business_group_id
3368: AND plip.bnft_or_option_rstrctn_cd = 'OPT'
3369: AND l_lf_evt_ocrd_dt BETWEEN plip.effective_start_date

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

3385: pl.bnft_or_option_rstrctn_cd,
3386: lbr.cvg_incr_r_decr_only_cd,
3387: lbr.mx_cvg_mlt_incr_num,
3388: lbr.mx_cvg_mlt_incr_wcf_num
3389: FROM ben_oipl_f oipl, ben_ler_bnft_rstrn_f lbr, ben_pl_f pl
3390: WHERE pl.pl_id = l_pl_id
3391: AND pl.business_group_id = p_business_group_id
3392: AND l_lf_evt_ocrd_dt BETWEEN pl.effective_start_date
3393: AND pl.effective_end_date