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_SUM dependencies on BEN_PL_F

Line 79: ben_pl_f pl

75: ,
76: pl.svgs_pl_flag object_type_cd
77: from ben_elig_per_f pep ,
78: ben_per_in_ler pil,
79: ben_pl_f pl
80: WHERE pep.person_id = c_per_id
81: and pep.pl_id = pl.pl_id
82: and pep.pgm_id is not null
83: and pep.pl_id is not null

Line 111: ben_pl_f pl ,

107: null object_type_cd
108: from ben_elig_per_opt_f pio ,
109: ben_elig_per_f pep ,
110: ben_per_in_ler pil,
111: ben_pl_f pl ,
112: ben_opt_f opt
113: WHERE pep.person_id = c_per_id
114: and pio.elig_per_id = pep.elig_per_id
115: and pio.opt_id = opt.opt_id

Line 146: ben_pl_f pl

142: ,
143: pl.svgs_pl_flag object_type_cd
144: from ben_elig_per_f pep ,
145: ben_per_in_ler pil,
146: ben_pl_f pl
147: WHERE pep.person_id = c_per_id
148: and pep.pl_id = pl.pl_id
149: and pep.pgm_id is null
150: and c_eff_date

Line 176: ben_pl_f pl ,

172: null object_type_cd
173: from ben_elig_per_opt_f pio ,
174: ben_elig_per_f pep ,
175: ben_per_in_ler pil,
176: ben_pl_f pl ,
177: ben_opt_f opt
178: WHERE pep.person_id = c_per_id
179: and pio.elig_per_id = pep.elig_per_id
180: and pio.opt_id = opt.opt_id