DBA Data[Home] [Help]

APPS.BEN_MNG_DPNT_BNF dependencies on BEN_PL_F

Line 405: FROM ben_pl_f pln

401: AND p_effective_date BETWEEN opt.effective_start_date AND opt.effective_end_date
402: AND NVL (opt.invk_wv_opt_flag, 'N') = 'Y'
403: UNION
404: SELECT NULL
405: FROM ben_pl_f pln
406: WHERE pln.pl_id = p_new_pl_id
407: AND p_effective_date BETWEEN pln.effective_start_date AND pln.effective_end_date
408: AND NVL (pln.invk_dcln_prtn_pl_flag, 'N') = 'Y';
409: