APPS.BEN_PREM_PL_OIPL_MONTHLY dependencies on BEN_OIPL_F

Line 22: from ben_oipl_f oipl, ben_pl_f pl

18: ,p_out_opt_id out nocopy number) is
19:
20: cursor c_opt(p_oipl_id number) is
21: select oipl.opt_id, oipl.pl_id, pl.pl_typ_id
22: from ben_oipl_f oipl, ben_pl_f pl
23: where oipl.oipl_id = p_oipl_id
24: and pl.pl_id = oipl.pl_id
25: and p_effective_date
26: between pl.effective_start_date