DBA Data[Home] [Help]

APPS.BEN_ENROLLMENT_ACTION_ITEMS dependencies on BEN_PL_DPNT_CVG_CTFN_F

Line 461: from ben_pl_dpnt_cvg_ctfn_f

457: and nvl(date_end, hr_api.g_eot)));
458: --
459: cursor c_ctfns_pl is
460: select 'x'
461: from ben_pl_dpnt_cvg_ctfn_f
462: where pl_id = p_pl_id
463: and business_group_id = p_business_group_id
464: and p_effective_date between effective_start_date
465: and effective_end_date

Line 3316: from ben_pl_dpnt_cvg_ctfn_f pl

3312: pl.ctfn_rqd_when_rl ctrrl,
3313: pl.rqd_flag,
3314: pl.rlshp_typ_cd ctrlshcd,
3315: pl.pl_id
3316: from ben_pl_dpnt_cvg_ctfn_f pl
3317: where pl.pl_id = v_pl_id
3318: and pl.business_group_id = p_business_group_id
3319: and p_effective_date between pl.effective_start_date
3320: and pl.effective_end_date