DBA Data[Home] [Help]

APPS.BEN_DETERMINE_DPNT_ELIGIBILITY dependencies on BEN_PL_F

Line 323: from ben_pl_f pl

319: pl.dpnt_cvg_strt_dt_cd,
320: pl.dpnt_cvg_strt_dt_rl,
321: pl.dpnt_cvg_end_dt_cd,
322: pl.dpnt_cvg_end_dt_rl
323: from ben_pl_f pl
324: where pl.pl_id = p_pl_id
325: and pl.business_group_id = p_business_group_id
326: and l_lf_evt_ocrd_dt
327: between pl.effective_start_date

Line 641: from ben_pl_f pln,

637: cursor c_dcln_pl_opt is
638: select decode(pln.invk_dcln_prtn_pl_flag,
639: 'N', nvl(opt.invk_wv_opt_flag,'N'),
640: 'Y') dcln_pl_opt_flag
641: from ben_pl_f pln,
642: ben_oipl_f oipl,
643: ben_opt_f opt
644: where pln.pl_id = p_pl_id
645: and oipl.oipl_id (+) = p_oipl_id