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_CLOSE_ENROLLMENT dependencies on BEN_LER_F

Line 523: ben_ler_f ler

519: ,ppf.business_group_id
520: ,pil.per_in_ler_stat_cd
521: from ben_per_in_ler pil,
522: per_all_people_f ppf,
523: ben_ler_f ler
524: where pil.per_in_ler_id = p_per_in_ler_id
525: and pil.business_group_id = p_business_group_id
526: and pil.per_in_ler_stat_cd = 'STRTD'
527: and ler.ler_id = pil.ler_id

Line 591: ben_ler_f ler

587: --
588: cursor c_ler is
589: select null
590: from ben_per_in_ler pil,
591: ben_ler_f ler
592: where pil.per_in_ler_id = p_per_in_ler_id
593: and pil.business_group_id = p_business_group_id
594: and ler.ler_id = pil.ler_id
595: and ler.business_group_id = p_business_group_id

Line 1978: ben_ler_f ler

1974: select distinct pil.person_id
1975: ,pil.per_in_ler_id
1976: from ben_per_in_ler pil,
1977: per_all_people_f per,
1978: ben_ler_f ler
1979: where pil.business_group_id = p_business_group_id
1980: and pil.per_in_ler_stat_cd = 'STRTD'
1981: and pil.person_id = per.person_id
1982: and pil.ler_id = ler.ler_id

Line 2485: ben_ler_f ler

2481: --
2482: cursor c_get_future_per_in_ler is
2483: select null
2484: from ben_per_in_ler pil,
2485: ben_ler_f ler
2486: where pil.lf_evt_ocrd_dt > p_lf_evt_ocrd_dt
2487: and pil.person_id = p_person_id
2488: and ler.ler_id = pil.ler_id
2489: and ler.typ_cd not in ( 'COMP','SCHEDDU', 'ABS', 'GSP', 'IREC') /* Bug 3981328 : Added Codes GSP, IREC, ABS */