APPS.BEN_DETERMINE_VARIABLE_RATES dependencies on BEN_OIPL_F

Line 390: from ben_oipl_f oipl

386: --
387: -- FONM
388: cursor c_opt(l_oipl_id number, cv_effective_date date) is
389: select opt_id
390: from ben_oipl_f oipl
391: where oipl_id = l_oipl_id
392: and cv_effective_date -- FONM nvl(p_lf_evt_ocrd_dt,p_effective_date)
393: between oipl.effective_start_date
394: and oipl.effective_end_date;

Line 417: ben_oipl_f cop

413: cursor c_apr2(cv_effective_date date) is
414: select apr.actl_prem_id
415: from ben_actl_prem_f apr,
416: ben_pl_f pln,
417: ben_oipl_f cop
418: where ((pln.pl_id = l_epe.pl_id
419: and pln.actl_prem_id = apr.actl_prem_id
420: and cv_effective_date -- FONM nvl(p_lf_evt_ocrd_dt,p_effective_date)
421: between pln.effective_start_date