DBA Data[Home] [Help]

APPS.BEN_MNG_DPNT_BNF dependencies on BEN_PL_F

Line 320: FROM ben_pl_f pln

316: AND p_effective_date BETWEEN opt.effective_start_date AND opt.effective_end_date
317: AND NVL (opt.invk_wv_opt_flag, 'N') = 'Y'
318: UNION
319: SELECT NULL
320: FROM ben_pl_f pln
321: WHERE pln.pl_id = p_new_pl_id
322: AND p_effective_date BETWEEN pln.effective_start_date AND pln.effective_end_date
323: AND NVL (pln.invk_dcln_prtn_pl_flag, 'N') = 'Y';
324: