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_MANAGE_LIFE_EVENTS dependencies on BEN_LEE_RSN_F

Line 10014: FROM ben_lee_rsn_f leer, ben_popl_enrt_typ_cycl_f petc

10010: c_effective_date date) is
10011: select 1 ordr_num ,
10012: leer.lee_rsn_id,
10013: NVL(leer.defer_deenrol_flag,'N')
10014: FROM ben_lee_rsn_f leer, ben_popl_enrt_typ_cycl_f petc
10015: WHERE leer.ler_id = p_ler_id
10016: AND leer.business_group_id = p_business_group_id
10017: AND c_effective_date BETWEEN leer.effective_start_date
10018: AND leer.effective_end_date

Line 10029: FROM ben_lee_rsn_f leer, ben_popl_enrt_typ_cycl_f petc

10025: UNION
10026: select 2 ordr_num ,
10027: leer.lee_rsn_id,
10028: NVL(leer.defer_deenrol_flag,'N')
10029: FROM ben_lee_rsn_f leer, ben_popl_enrt_typ_cycl_f petc
10030: WHERE leer.ler_id = p_ler_id
10031: AND leer.business_group_id = p_business_group_id
10032: AND c_effective_date BETWEEN leer.effective_start_date
10033: AND leer.effective_end_date