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 208: ben_per_in_ler pil

204: --
205: Cursor c1 (c_prtt_enrt_rslt_id number) is
206: Select ecd.dpnt_person_id, ecd.cvg_strt_dt, ecd.cvg_thru_dt
207: From ben_elig_cvrd_dpnt_f ecd,
208: ben_per_in_ler pil
209: Where ecd.prtt_enrt_rslt_id is not NULL
210: and ecd.prtt_enrt_rslt_id = c_prtt_enrt_rslt_id
211: and ecd.business_group_id = p_business_group_id
212: and p_effective_date between

Line 776: from ben_per_in_ler pil

772: -- of pil.ler_id
773: --
774: cursor c_person is
775: select pil.person_id
776: from ben_per_in_ler pil
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

Line 1878: ,ben_per_in_ler b

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

Line 1897: From ben_per_in_ler b,

1893: Cursor C_pil is
1894: Select b.PER_IN_LER_ID
1895: ,b.lf_evt_ocrd_dt
1896: ,b.ler_id
1897: From ben_per_in_ler b,
1898: ben_ler_f ler
1899: Where b.per_in_ler_stat_cd = 'STRTD'
1900: and b.person_id = p_person_id
1901: and b.ler_id = ler.ler_id