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

Line 52: from ben_per_in_ler pil

48: (c_person_id number
49: )
50: is
51: select pil.per_in_ler_id
52: from ben_per_in_ler pil
53: where pil.person_id = c_person_id
54: and pil.per_in_ler_stat_cd not in ('VOIDD', 'BCKDT')
55: order by pil.per_in_ler_id desc;
56: --

Line 721: ben_per_in_ler tab3

717: ,tab2.prtn_end_dt pep_ped
718: ,tab3.per_in_ler_stat_cd
719: from ben_elig_per_opt_f tab1,
720: ben_elig_per_f tab2,
721: ben_per_in_ler tab3
722: where tab1.opt_id is not null
723: and tab1.elig_per_id = tab2.elig_per_id
724: and tab3.per_in_ler_id = tab1.per_in_ler_id
725: and c_effective_date