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

Line 65: from ben_per_in_ler pil

61: cursor c_pil(p_ler_id number,
62: p_life_event_date date,
63: p_person_id number) is
64: select pil.per_in_ler_id
65: from ben_per_in_ler pil
66: where pil.ler_id = p_ler_id
67: and pil.lf_evt_ocrd_dt = p_life_event_date
68: and pil.person_id = p_person_id
69: and pil.per_in_ler_stat_cd = 'STRTD' ;

Line 1845: from ben_per_in_ler pil

1841: and pgm.effective_end_date ;
1842: --
1843: cursor c_pil is
1844: select pil.per_in_ler_id
1845: from ben_per_in_ler pil
1846: where pil.ler_id =p_ler_id
1847: and pil.person_id = p_person_id
1848: and pil.lf_evt_ocrd_dt = p_life_event_date
1849: and pil.per_in_ler_stat_cd = 'STRTD' ;