DBA Data[Home] [Help]

APPS.BEN_ENROLMENT_REQUIREMENTS2 dependencies on BEN_LER_CHG_PLIP_ENRT_F

Line 391: FROM ben_ler_chg_plip_enrt_f lep

387: )
388: IS
389: SELECT lep.dflt_enrt_cd,
390: lep.dflt_enrt_rl
391: FROM ben_ler_chg_plip_enrt_f lep
392: WHERE c_plip_id = lep.plip_id
393: AND c_ler_id = lep.ler_id
394: AND c_effdt BETWEEN lep.effective_start_date
395: AND lep.effective_end_date;