DBA Data[Home] [Help]

APPS.BEN_MNG_DPNT_BNF dependencies on BEN_OPT_F

Line 397: ben_opt_f opt

393: */
394: CURSOR c_waive_pl_opt IS
395: SELECT NULL
396: FROM ben_oipl_f oipl,
397: ben_opt_f opt
398: WHERE oipl.opt_id = opt.opt_id
399: AND oipl.oipl_id = p_new_oipl_id
400: AND p_effective_date BETWEEN oipl.effective_start_date AND oipl.effective_end_date
401: AND p_effective_date BETWEEN opt.effective_start_date AND opt.effective_end_date