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_MNG_DPNT_BNF dependencies on BEN_PER_IN_LER

Line 112: ben_per_in_ler pil,

108: cursor c_num_cvd_dpnt is
109: select count(old.elig_cvrd_dpnt_id)
110: from ben_elig_cvrd_dpnt_f old,
111: ben_elig_dpnt new,
112: ben_per_in_ler pil,
113: ben_per_in_ler pil2
114: where old.prtt_enrt_rslt_id = l_old_prtt_enrt_rslt_id
115: and old.cvg_strt_dt is not null
116: and nvl(old.cvg_thru_dt, hr_api.g_eot) >= nvl(pil2.lf_evt_ocrd_dt - 1,

Line 113: ben_per_in_ler pil2

109: select count(old.elig_cvrd_dpnt_id)
110: from ben_elig_cvrd_dpnt_f old,
111: ben_elig_dpnt new,
112: ben_per_in_ler pil,
113: ben_per_in_ler pil2
114: where old.prtt_enrt_rslt_id = l_old_prtt_enrt_rslt_id
115: and old.cvg_strt_dt is not null
116: and nvl(old.cvg_thru_dt, hr_api.g_eot) >= nvl(pil2.lf_evt_ocrd_dt - 1,
117: hr_api.g_eot)

Line 140: ben_per_in_ler pil,

136: new.elig_dpnt_id new_dpnt
137: from ben_elig_cvrd_dpnt_f old,
138: ben_elig_dpnt new,
139: per_contact_relationships pcr,
140: ben_per_in_ler pil,
141: ben_per_in_ler pil2
142: where old.prtt_enrt_rslt_id = l_old_prtt_enrt_rslt_id
143: and old.cvg_strt_dt is not null
144: and nvl(old.cvg_thru_dt, hr_api.g_eot) >= nvl(pil2.lf_evt_ocrd_dt - 1,

Line 141: ben_per_in_ler pil2

137: from ben_elig_cvrd_dpnt_f old,
138: ben_elig_dpnt new,
139: per_contact_relationships pcr,
140: ben_per_in_ler pil,
141: ben_per_in_ler pil2
142: where old.prtt_enrt_rslt_id = l_old_prtt_enrt_rslt_id
143: and old.cvg_strt_dt is not null
144: and nvl(old.cvg_thru_dt, hr_api.g_eot) >= nvl(pil2.lf_evt_ocrd_dt - 1,
145: hr_api.g_eot)

Line 317: ben_per_in_ler pil

313: ecd.dpnt_person_id,
314: ecd.elig_per_elctbl_chc_id,
315: ecd.object_version_number
316: from ben_elig_cvrd_dpnt_f ecd,
317: ben_per_in_ler pil
318: where ecd.prtt_enrt_rslt_id = p_new_prtt_enrt_rslt_id
319: and ecd.cvg_strt_dt is not null
320: and nvl(ecd.cvg_thru_dt, hr_api.g_eot) = hr_api.g_eot
321: and ecd.business_group_id = p_business_group_id

Line 331: ben_per_in_ler pil

327: --
328: cursor old_bnf_c is
329: select pbn.*
330: from ben_pl_bnf_f pbn,
331: ben_per_in_ler pil
332: where pbn.prtt_enrt_rslt_id = l_old_prtt_enrt_rslt_id
333: and pbn.business_group_id = p_business_group_id
334: and p_effective_date between pbn.effective_start_date
335: and pbn.effective_end_date

Line 347: ben_per_in_ler pil,

343: v_grp_rlshp_cd varchar2 ) is
344: select count(old.elig_cvrd_dpnt_id)
345: from ben_elig_cvrd_dpnt_f old,
346: ben_elig_dpnt new,
347: ben_per_in_ler pil,
348: ben_per_in_ler pil2,
349: per_contact_relationships pcr
350: where old.prtt_enrt_rslt_id = l_old_prtt_enrt_rslt_id
351: and old.cvg_strt_dt is not null

Line 348: ben_per_in_ler pil2,

344: select count(old.elig_cvrd_dpnt_id)
345: from ben_elig_cvrd_dpnt_f old,
346: ben_elig_dpnt new,
347: ben_per_in_ler pil,
348: ben_per_in_ler pil2,
349: per_contact_relationships pcr
350: where old.prtt_enrt_rslt_id = l_old_prtt_enrt_rslt_id
351: and old.cvg_strt_dt is not null
352: and nvl(old.cvg_thru_dt, hr_api.g_eot) >= nvl(pil2.lf_evt_ocrd_dt - 1,

Line 421: from ben_per_in_ler pil,

417:
418: --Bug 14740884
419: cursor c_prev_pil(c_per_in_ler_id number ) is
420: select pil.per_in_ler_id
421: from ben_per_in_ler pil,
422: ben_ler_f ler
423: where pil.per_in_ler_id not in (c_per_in_ler_id)
424: and pil.person_id = p_person_id
425: and pil.ler_id = ler.ler_id