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 522: ben_ler_f ler

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

Line 590: ben_ler_f ler

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

Line 1938: ben_ler_f ler

1934: select distinct pil.person_id
1935: ,pil.per_in_ler_id
1936: from ben_per_in_ler pil,
1937: per_all_people_f per,
1938: ben_ler_f ler
1939: where pil.business_group_id = p_business_group_id
1940: and pil.per_in_ler_stat_cd = 'STRTD'
1941: and pil.person_id = per.person_id
1942: and pil.ler_id = ler.ler_id

Line 2445: ben_ler_f ler

2441: --
2442: cursor c_get_future_per_in_ler is
2443: select null
2444: from ben_per_in_ler pil,
2445: ben_ler_f ler
2446: where pil.lf_evt_ocrd_dt > p_lf_evt_ocrd_dt
2447: and pil.person_id = p_person_id
2448: and ler.ler_id = pil.ler_id
2449: and ler.typ_cd not in ( 'COMP','SCHEDDU', 'ABS', 'GSP', 'IREC') /* Bug 3981328 : Added Codes GSP, IREC, ABS */