DBA Data[Home] [Help]

APPS.BEN_ENROLLMENT_ACTION_ITEMS dependencies on BEN_PTIP_F

Line 2316: from ben_ptip_f ptip

2312: -- cursor to retrieve dpnts' required-info-flags at the ptip level
2313: --
2314: cursor c_dpnt_ptip (p_ptip_id number) is
2315: select ptip.susp_if_ctfn_not_dpnt_flag
2316: from ben_ptip_f ptip
2317: where ptip.ptip_id = p_ptip_id
2318: and ptip.business_group_id = p_business_group_id
2319: and p_effective_date between
2320: ptip.effective_start_date and ptip.effective_end_date;

Line 3247: from ben_ptip_f ptip

3243: ptip.susp_if_dpnt_adr_nt_prv_cd,
3244: ptip.susp_if_ctfn_not_dpnt_flag,
3245: ptip.dpnt_ctfn_determine_cd,
3246: ptip.dpnt_cvg_no_ctfn_rqd_flag
3247: from ben_ptip_f ptip
3248: where ptip.ptip_id = p_ptip_id
3249: and ptip.business_group_id = p_business_group_id
3250: and p_effective_date between
3251: ptip.effective_start_date and ptip.effective_end_date;