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_PEP_CACHE1 dependencies on BEN_PER_IN_LER

Line 54: ben_per_in_ler pil

50: is
51: select /*+ benppch1.get_curroiplippep_dets.c_piloiplip_dets */
52: pep.elig_per_id
53: from ben_elig_per_f pep,
54: ben_per_in_ler pil
55: where pep.person_id = c_person_id
56: and pep.pgm_id = c_pgm_id
57: and pep.plip_id = c_plip_id
58: and c_effective_date

Line 89: ben_per_in_ler pil

85: is
86: select /*+ benppch1.get_curroiplippep_dets.c_piloiplipnip_dets */
87: pep.elig_per_id
88: from ben_elig_per_f pep,
89: ben_per_in_ler pil
90: where pep.person_id = c_person_id
91: and pep.pgm_id is null
92: and pep.plip_id = c_plip_id
93: and c_effective_date

Line 199: ben_per_in_ler pil

195: pep.elig_per_id,
196: pep.prtn_strt_dt,
197: pep.prtn_end_dt
198: from ben_elig_per_f pep,
199: ben_per_in_ler pil
200: where pep.person_id = c_person_id
201: and pep.pgm_id = c_pgm_id
202: and pep.pl_id = c_pl_id
203: and c_effective_date

Line 239: ben_per_in_ler pil

235: pep.elig_per_id,
236: pep.prtn_strt_dt,
237: pep.prtn_end_dt
238: from ben_elig_per_f pep,
239: ben_per_in_ler pil
240: where pep.person_id = c_person_id
241: and pep.pgm_id is null
242: and pep.pl_id = c_pl_id
243: and c_effective_date