DBA Data[Home] [Help]

APPS.BEN_CWB_SINGLE_PER_PROCESS_PKG dependencies on BEN_ENRT_PERD

Line 78: ,ben_enrt_perd enp

74: (v_pl_id in number
75: ,v_search_date in date) is
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

Line 512: BEN_ENRT_PERD enrt

508: cursor csr_pl_dsgn_hrchy(p_group_pl_id number
509: ,p_lf_evt_dt date) is
510: select HRCHY_TO_USE_CD
511: from
512: BEN_ENRT_PERD enrt
513: , ben_cwb_pl_dsgn dsgn
514: where dsgn.pl_id = p_group_pl_id
515: and enrt.enrt_perd_id = dsgn.enrt_perd_id
516: and dsgn.lf_evt_ocrd_dt= p_lf_evt_dt;