880: --
881: CURSOR c_ptip
882: IS
883: SELECT ptip.dpnt_dsgn_cd 884: FROM ben_ptip_f ptip 885: WHERE ptip.ptip_id = rslt_ptip_id
886: AND ptip.business_group_id = p_business_group_id
887: AND p_effective_date BETWEEN ptip.effective_start_date
888: AND ptip.effective_end_date;