[Home] [Help]
100: --
101: l_opt_id number ;
102: cursor c_opt(p_oipl_id number,p_effective_date date) is
103: select opt_id
104: from ben_oipl_f otp
105: where otp.oipl_id = p_oipl_id
106: and p_effective_date between otp.effective_start_date
107: and otp.effective_end_date ;
108: --