DBA Data[Home] [Help]

APPS.BEN_DETERMINE_COVERAGE dependencies on BEN_PL_TYP_F

Line 682: from ben_pl_typ_f

678: effective_start_date and effective_end_date
679: and mx_enrd_alwd_ovrid_num is not null
680: union
681: select '2', mx_enrl_alwd_num
682: from ben_pl_typ_f
683: where pl_typ_id=l_epe.pl_typ_id
684: and business_group_id=l_epe.business_group_id
685: and cv_effective_date -- FONM nvl(p_lf_evt_ocrd_dt,p_effective_date)
686: between