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