DBA Data[Home] [Help]

APPS.BEN_ENROLLMENT_ACTION_ITEMS dependencies on BEN_PL_DPNT_CVG_CTFN_F

Line 474: from ben_pl_dpnt_cvg_ctfn_f

470: and nvl(date_end, hr_api.g_eot)));
471: --
472: cursor c_ctfns_pl is
473: select 'x'
474: from ben_pl_dpnt_cvg_ctfn_f
475: where pl_id = p_pl_id
476: and business_group_id = p_business_group_id
477: and p_effective_date between effective_start_date
478: and effective_end_date

Line 3329: from ben_pl_dpnt_cvg_ctfn_f pl

3325: pl.ctfn_rqd_when_rl ctrrl,
3326: pl.rqd_flag,
3327: pl.rlshp_typ_cd ctrlshcd,
3328: pl.pl_id
3329: from ben_pl_dpnt_cvg_ctfn_f pl
3330: where pl.pl_id = v_pl_id
3331: and pl.business_group_id = p_business_group_id
3332: and p_effective_date between pl.effective_start_date
3333: and pl.effective_end_date