101: pen.effective_start_date,
102: pen.effective_end_date,
103: pen.uom
104: from ben_prtt_enrt_rslt_f pen, 105: ben_oipl_f opt 106: where pen.prtt_enrt_rslt_id = c_prtt_enrt_rslt_id
107: and pen.prtt_enrt_rslt_stat_cd is null
108: and opt.oipl_id(+)=pen.oipl_id
109: and pen.enrt_cvg_strt_dt between opt.effective_start_date(+)