DBA Data[Home] [Help]

APPS.BEN_ENROLLMENT_ACTION_ITEMS dependencies on BEN_PTIP_F

Line 2329: from ben_ptip_f ptip

2325: -- cursor to retrieve dpnts' required-info-flags at the ptip level
2326: --
2327: cursor c_dpnt_ptip (p_ptip_id number) is
2328: select ptip.susp_if_ctfn_not_dpnt_flag
2329: from ben_ptip_f ptip
2330: where ptip.ptip_id = p_ptip_id
2331: and ptip.business_group_id = p_business_group_id
2332: and p_effective_date between
2333: ptip.effective_start_date and ptip.effective_end_date;

Line 3260: from ben_ptip_f ptip

3256: ptip.susp_if_dpnt_adr_nt_prv_cd,
3257: ptip.susp_if_ctfn_not_dpnt_flag,
3258: ptip.dpnt_ctfn_determine_cd,
3259: ptip.dpnt_cvg_no_ctfn_rqd_flag
3260: from ben_ptip_f ptip
3261: where ptip.ptip_id = p_ptip_id
3262: and ptip.business_group_id = p_business_group_id
3263: and p_effective_date between
3264: ptip.effective_start_date and ptip.effective_end_date;