APPS.BEN_CWB_SINGLE_PER_PROCESS_PKG dependencies on BEN_WTHN_YR_PERD
Line 80: ,ben_wthn_yr_perd wyr
76: select max(enp.data_freeze_date) data_freeze_date
77: from ben_popl_enrt_typ_cycl_f petc
78: ,ben_enrt_perd enp
79: ,ben_yr_perd yr 80: ,ben_wthn_yr_perd wyr 81: where petc.pl_id = v_pl_id
82: and v_search_date between petc.effective_start_date and petc.effective_end_date
83: and petc.popl_enrt_typ_cycl_id = enp.popl_enrt_typ_cycl_id
84: and yr.yr_perd_id = enp.yr_perd_id