DBA Data[Home] [Help]

APPS.BEN_ENROLLMENT_ACTION_ITEMS dependencies on BEN_PTIP_DPNT_CVG_CTFN_F

Line 456: from ben_ptip_dpnt_cvg_ctfn_f

452: and nvl(date_end, hr_api.g_eot)));
453: --
454: cursor c_ctfns_ptip is
455: select 'x'
456: from ben_ptip_dpnt_cvg_ctfn_f
457: where ptip_id = p_ptip_id
458: and business_group_id = p_business_group_id
459: and p_effective_date between effective_start_date
460: and effective_end_date

Line 3378: from ben_ptip_dpnt_cvg_ctfn_f ptip

3374: ptip.ctfn_rqd_when_rl ctrrl,
3375: ptip.rqd_flag,
3376: ptip.rlshp_typ_cd ctrlshcd,
3377: ptip.ptip_id
3378: from ben_ptip_dpnt_cvg_ctfn_f ptip
3379: where ptip.ptip_id = v_ptip_id
3380: and ptip.business_group_id = p_business_group_id
3381: and p_effective_date between ptip.effective_start_date
3382: and ptip.effective_end_date