DBA Data[Home] [Help]

APPS.BEN_CWB_PL_DSGN_PKG dependencies on BEN_ENRT_PERD

Line 266: ,ben_enrt_perd enp

262: ,enp.sal_chg_reason_cd salary_change_reason
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))

Line 365: ,ben_enrt_perd enp

361: ,ben_acty_base_rt_f oc
362: ,per_business_groups bg
363: ,fnd_currencies cur
364: ,ben_popl_enrt_typ_cycl_f petc
365: ,ben_enrt_perd enp
366: where pl.group_pl_id = p_group_pl_id
367: and p_effective_date between pl.effective_start_date and
368: pl.effective_end_date
369: and pl.pl_stat_cd in ('A', 'I')