6317: ) return varchar2 is
6318:
6319: cursor c_oipl is
6320: select opt_id,pl_id
6321: from ben_oipl_f cop
6322: where cop.oipl_id = p_oipl_id
6323: and p_effective_date between cop.effective_start_date
6324: and cop.effective_end_date;
6325:
7296: and pon.effective_end_date;
7297:
7298: cursor c_oipl is
7299: select pl_id
7300: from ben_oipl_f cop
7301: where cop.oipl_id = p_oipl_id
7302: and p_effective_date between cop.effective_start_date
7303: and cop.effective_end_date;
7304: