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_DEFAULT_ENRT dependencies on BEN_PIL_ELCTBL_CHC_POPL

Line 781: from ben_pil_elctbl_chc_popl pel

777: where
778: pil.business_group_id = p_business_group_id -- 2828045
779: and pil.per_in_ler_id in
780: (select pel.per_in_ler_id
781: from ben_pil_elctbl_chc_popl pel
782: where pel.business_group_id = pil.business_group_id
783: and pel.per_in_ler_id = pil.per_in_ler_id
784: and pel.dflt_enrt_dt <= l_effective_date
785: and pel.dflt_asnd_dt is NULL

Line 1877: From Ben_pil_elctbl_chc_popl a

1873: ,b.ler_id
1874: ,a.dflt_enrt_dt
1875: ,a.enrt_perd_strt_dt
1876: ,a.enrt_perd_end_dt
1877: From Ben_pil_elctbl_chc_popl a
1878: ,ben_per_in_ler b
1879: ,ben_ler_f ler
1880: Where a.PIL_ELCTBL_POPL_STAT_CD = 'STRTD'
1881: --and a.business_group_id = b.business_group_id