DBA Data[Home] [Help]

APPS.BEN_MNG_DPNT_BNF dependencies on BEN_OPT_F

Line 312: ben_opt_f opt

308: */
309: CURSOR c_waive_pl_opt IS
310: SELECT NULL
311: FROM ben_oipl_f oipl,
312: ben_opt_f opt
313: WHERE oipl.opt_id = opt.opt_id
314: AND oipl.oipl_id = p_new_oipl_id
315: AND p_effective_date BETWEEN oipl.effective_start_date AND oipl.effective_end_date
316: AND p_effective_date BETWEEN opt.effective_start_date AND opt.effective_end_date