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_PER_IN_LER

Line 222: ben_per_in_ler pil

218: --
219: Cursor c1 (c_prtt_enrt_rslt_id number) is
220: Select ecd.dpnt_person_id, ecd.cvg_strt_dt, ecd.cvg_thru_dt
221: From ben_elig_cvrd_dpnt_f ecd,
222: ben_per_in_ler pil
223: Where ecd.prtt_enrt_rslt_id is not NULL
224: and ecd.prtt_enrt_rslt_id = c_prtt_enrt_rslt_id
225: and ecd.business_group_id = p_business_group_id
226: and p_effective_date between

Line 790: from ben_per_in_ler pil

786: -- of pil.ler_id
787: --
788: cursor c_person is
789: select pil.person_id
790: from ben_per_in_ler pil
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

Line 2027: ,ben_per_in_ler b

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
2031: and a.business_group_id = p_business_group_id

Line 2046: From ben_per_in_ler b,

2042: Cursor C_pil is
2043: Select b.PER_IN_LER_ID
2044: ,b.lf_evt_ocrd_dt
2045: ,b.ler_id
2046: From ben_per_in_ler b,
2047: ben_ler_f ler
2048: Where b.per_in_ler_stat_cd = 'STRTD'
2049: and b.person_id = p_person_id
2050: and b.ler_id = ler.ler_id