[Home] [Help]
172: AND c_effective_date BETWEEN abr.effective_start_date
173: AND abr.effective_end_date;
174: cursor c_oipl (p_pl_id number) is
175: select opt.oipl_id
176: from ben_oipl_f opt
177: where pl_id = p_pl_id
178: and p_effective_date between opt.effective_start_date
179: and opt.effective_end_date;
180: --