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 795: from ben_pil_elctbl_chc_popl pel

791: where
792: pil.business_group_id = p_business_group_id -- 2828045
793: and pil.per_in_ler_id in
794: (select pel.per_in_ler_id
795: from ben_pil_elctbl_chc_popl pel
796: where pel.business_group_id = pil.business_group_id
797: and pel.per_in_ler_id = pil.per_in_ler_id
798: and pel.dflt_enrt_dt <= l_effective_date
799: and pel.dflt_asnd_dt is NULL

Line 1492: FROM ben_pil_elctbl_chc_popl pel

1488:
1489: --Start AMN Bug 14006027
1490: cursor c_pl_enrt_dt(v_elig_per_elctbl_chc_id number) is
1491: SELECT pel.enrt_perd_strt_dt
1492: FROM ben_pil_elctbl_chc_popl pel
1493: , ben_elig_per_elctbl_chc epe
1494: WHERE pel.pil_elctbl_chc_popl_id = epe.pil_elctbl_chc_popl_id
1495: AND epe.elig_per_elctbl_chc_id = v_elig_per_elctbl_chc_id;
1496:

Line 2026: From Ben_pil_elctbl_chc_popl a

2022: ,b.ler_id
2023: ,a.dflt_enrt_dt
2024: ,a.enrt_perd_strt_dt
2025: ,a.enrt_perd_end_dt
2026: From Ben_pil_elctbl_chc_popl a
2027: ,ben_per_in_ler b
2028: ,ben_ler_f ler
2029: Where a.PIL_ELCTBL_POPL_STAT_CD = 'STRTD'
2030: --and a.business_group_id = b.business_group_id