DBA Data[Home] [Help]

APPS.BEN_ENROLLMENT_ACTION_ITEMS dependencies on BEN_PTIP_DPNT_CVG_CTFN_F

Line 443: from ben_ptip_dpnt_cvg_ctfn_f

439: and nvl(date_end, hr_api.g_eot)));
440: --
441: cursor c_ctfns_ptip is
442: select 'x'
443: from ben_ptip_dpnt_cvg_ctfn_f
444: where ptip_id = p_ptip_id
445: and business_group_id = p_business_group_id
446: and p_effective_date between effective_start_date
447: and effective_end_date

Line 3365: from ben_ptip_dpnt_cvg_ctfn_f ptip

3361: ptip.ctfn_rqd_when_rl ctrrl,
3362: ptip.rqd_flag,
3363: ptip.rlshp_typ_cd ctrlshcd,
3364: ptip.ptip_id
3365: from ben_ptip_dpnt_cvg_ctfn_f ptip
3366: where ptip.ptip_id = v_ptip_id
3367: and ptip.business_group_id = p_business_group_id
3368: and p_effective_date between ptip.effective_start_date
3369: and ptip.effective_end_date