DBA Data[Home] [Help]

APPS.BEN_NEWLY_INELIGIBLE dependencies on BEN_PL_F

Line 648: from ben_pl_f pl

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