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 68: from ben_per_in_ler pil

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

Line 1848: from ben_per_in_ler pil

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