eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_CVG_CACHE dependencies on BEN_PL_F

Line 111: ben_pl_f pln

107: pln.bnft_or_option_rstrctn_cd,
108: pln.mx_cvg_rl,
109: pln.mn_cvg_rl
110: from ben_cvg_amt_calc_mthd_f cvg,
111: ben_pl_f pln
112: where pln.pl_id = c_pln_id
113: and cvg.pl_id = pln.pl_id
114: and c_effective_date
115: between pln.effective_start_date

Line 185: ben_pl_f pln

181: pln.mx_cvg_rl,
182: pln.mn_cvg_rl
183: from ben_cvg_amt_calc_mthd_f cvg,
184: ben_plip_f cpp,
185: ben_pl_f pln
186: where cpp.plip_id = c_plip_id
187: and cvg.plip_id = cpp.plip_id
188: and cpp.pl_id = pln.pl_id
189: and c_effective_date

Line 264: ben_pl_f pln

260: pln.mx_cvg_rl,
261: pln.mn_cvg_rl
262: from ben_cvg_amt_calc_mthd_f cvg,
263: ben_oipl_f cop,
264: ben_pl_f pln
265: where cop.oipl_id = c_oipl_id
266: and cvg.oipl_id = cop.oipl_id
267: and cop.pl_id = pln.pl_id
268: and c_effective_date