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_COP_CACHE dependencies on BEN_POPL_YR_PERD

Line 36: -- ben_popl_yr_perd cpy,

32: cop.trk_inelig_per_flag
33: from
34: ben_pl_f pln,
35: ben_oipl_f cop
36: -- ben_popl_yr_perd cpy,
37: -- ben_yr_perd yrp
38: where pln.pl_id = c_pl_id
39: and c_effective_date
40: between pln.effective_start_date

Line 48: from ben_popl_yr_perd cpy,

44: between cop.effective_start_date
45: and cop.effective_end_date
46: and (p_mode IN ('P','G','D') or
47: exists (select null
48: from ben_popl_yr_perd cpy,
49: ben_yr_perd yrp
50: where cpy.pl_id = pln.pl_id
51: and cpy.yr_perd_id = yrp.yr_perd_id
52: and c_effective_date

Line 74: -- ben_popl_yr_perd cpy,

70: cop.drvbl_fctr_apls_rts_flag,
71: cop.trk_inelig_per_flag
72: from ben_pl_f pln,
73: ben_oipl_f cop,
74: -- ben_popl_yr_perd cpy,
75: -- ben_yr_perd yrp,
76: ben_opt_f opt
77: where pln.pl_id = c_pl_id
78: and c_effective_date

Line 87: from ben_popl_yr_perd cpy,

83: between cop.effective_start_date
84: and cop.effective_end_date
85: and (p_mode IN ('P','G','D') or
86: exists (select null
87: from ben_popl_yr_perd cpy,
88: ben_yr_perd yrp
89: where cpy.pl_id = pln.pl_id
90: and cpy.yr_perd_id = yrp.yr_perd_id
91: and c_effective_date