APPS.BEN_ICM_LIFE_EVENTS dependencies on BEN_PL_F

Line 48: FROM ben_pl_f pln

44: CURSOR c_pl_info (p_pl_id NUMBER)
45: IS
46: SELECT pln.rt_strt_dt_cd, pln.rt_strt_dt_rl, pln.rt_end_dt_cd,
47: pln.rt_end_dt_rl, pln.bnf_dsgn_cd
48: FROM ben_pl_f pln
49: WHERE pln.pl_id = p_pl_id
50: AND p_effective_date BETWEEN pln.effective_start_date
51: AND pln.effective_end_date;
52: