APPS.BEN_CWB_PL_DSGN_PKG dependencies on BEN_YR_PERD

Line 267: ,ben_yr_perd yr

263: ,enp.data_freeze_date data_freeze_date
264: from ben_pl_f pl
265: ,ben_popl_enrt_typ_cycl_f petc
266: ,ben_enrt_perd enp
267: ,ben_yr_perd yr
268: ,ben_wthn_yr_perd wyr
269: where pl.pl_id = p_group_pl_id
270: and nvl(p_effective_date,nvl(enp.data_freeze_date,p_lf_evt_ocrd_dt))
271: between pl.effective_start_date and pl.effective_end_date