APPS.BEN_PREM_PRTT_CREDITS_MO dependencies on BEN_OIPL_F

Line 212: select opt_id from ben_oipl_f oipl

208: (p_pgm_id is null and cpy.pl_id = p_pl_id));
209: l_pl_yr c_pl_yr%rowtype;
210:
211: cursor c_opt(l_oipl_id number) is
212: select opt_id from ben_oipl_f oipl
213: where oipl.oipl_id = l_oipl_id
214: and p_effective_date between
215: oipl.effective_start_date and oipl.effective_end_date;
216: l_opt c_opt%rowtype;