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_PER_IN_LER

Line 49: ben_per_in_ler pil,

45: 'PGM' type
46: ,
47: pgm.pgm_typ_cd object_type_cd
48: from ben_elig_per_f pep,
49: ben_per_in_ler pil,
50: ben_pgm_f pgm
51: WHERE pep.person_id = c_per_id
52: and pep.pgm_id = pgm.pgm_id
53: and pep.pl_id is null

Line 78: ben_per_in_ler pil,

74: 'PL' type
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

Line 110: ben_per_in_ler pil,

106: ,
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

Line 145: ben_per_in_ler pil,

141: 'PL' type
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

Line 175: ben_per_in_ler pil,

171: ,
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