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 10470: FROM ben_lee_rsn_f leer, ben_popl_enrt_typ_cycl_f petc

10466: c_effective_date date) is
10467: select 1 ordr_num ,
10468: leer.lee_rsn_id,
10469: NVL(leer.defer_deenrol_flag,'N')
10470: FROM ben_lee_rsn_f leer, ben_popl_enrt_typ_cycl_f petc
10471: WHERE leer.ler_id = p_ler_id
10472: AND leer.business_group_id = p_business_group_id
10473: AND c_effective_date BETWEEN leer.effective_start_date
10474: AND leer.effective_end_date

Line 10485: FROM ben_lee_rsn_f leer, ben_popl_enrt_typ_cycl_f petc

10481: UNION
10482: select 2 ordr_num ,
10483: leer.lee_rsn_id,
10484: NVL(leer.defer_deenrol_flag,'N')
10485: FROM ben_lee_rsn_f leer, ben_popl_enrt_typ_cycl_f petc
10486: WHERE leer.ler_id = p_ler_id
10487: AND leer.business_group_id = p_business_group_id
10488: AND c_effective_date BETWEEN leer.effective_start_date
10489: AND leer.effective_end_date