DBA Data[Home] [Help]

APPS.BEN_NEWLY_INELIGIBLE dependencies on BEN_PL_F

Line 646: from ben_pl_f pl

642: and lee.effective_end_date;
643: --
644: cursor c_imptd(v_pl_id in number) is
645: select 'Y'
646: from ben_pl_f pl
647: where pl.pl_id = v_pl_id
648: and pl.business_group_id + 0 = p_business_group_id
649: and p_effective_date between
650: pl.effective_start_date and pl.effective_end_date