APPS.BEN_PREMIUM_CONCURRENT dependencies on BEN_PRTT_ENRT_RSLT_F
Line 564: from ben_prtt_enrt_rslt_f pen
560: ) is
561:
562: cursor c_person (p_effective_date date) is
563: select distinct pen.person_id 564: from ben_prtt_enrt_rslt_f pen 565: where pen.prtt_enrt_rslt_stat_cd is null
566: and pen.sspndd_flag = 'N'
567: and pen.comp_lvl_cd not in ('PLANFC', 'PLANIMP') -- not a dummy plan
568: -- cvg starts sometime before end of next month: