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_PLN_CACHE dependencies on BEN_YR_PERD

Line 66: -- ben_yr_perd yrp

62: ben_pl_f pln,
63: ben_pl_typ_f ptp,
64: ben_plip_f plp
65: -- ben_popl_yr_perd cpy,
66: -- ben_yr_perd yrp
67: where
68: /* Hint joins */
69: plp.pgm_id = c_pgm_id
70: and pln.pl_id = plp.pl_id

Line 81: ben_yr_perd yrp

77: and ptp.effective_end_date
78: and (p_mode IN ('P','G','D') or
79: exists (select null
80: from ben_popl_yr_perd cpy,
81: ben_yr_perd yrp
82: where cpy.pl_id = pln.pl_id
83: and cpy.yr_perd_id = yrp.yr_perd_id
84: and c_effective_date
85: between yrp.start_date

Line 264: -- ben_yr_perd yrp

260: ben_pl_f pln,
261: ben_pl_typ_f ptp,
262: ben_plip_f plp
263: -- ben_popl_yr_perd cpy,
264: -- ben_yr_perd yrp
265: where
266: /* Hint joins */
267: plp.pgm_id = c_pgm_id
268: and pln.pl_id = plp.pl_id

Line 281: ben_yr_perd yrp

277:
278: and (p_mode in ('G','D') or
279: exists (select null
280: from ben_popl_yr_perd cpy,
281: ben_yr_perd yrp
282: where cpy.pl_id = pln.pl_id
283: and cpy.yr_perd_id = yrp.yr_perd_id
284: and c_effective_date
285: between yrp.start_date