DBA Data[Home] [Help]

APPS.BEN_DETERMINE_COVERAGE dependencies on BEN_PL_TYP_F

Line 658: from ben_pl_typ_f

654: effective_start_date and effective_end_date
655: and mx_enrd_alwd_ovrid_num is not null
656: union
657: select '2', mx_enrl_alwd_num
658: from ben_pl_typ_f
659: where pl_typ_id=l_epe.pl_typ_id
660: and business_group_id=l_epe.business_group_id
661: and cv_effective_date -- FONM nvl(p_lf_evt_ocrd_dt,p_effective_date)
662: between