DBA Data[Home] [Help]

APPS.BEN_DETERMINE_DPNT_ELIGIBILITY dependencies on BEN_PL_F

Line 321: from ben_pl_f pl

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

Line 637: from ben_pl_f pln,

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