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 = p_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 = p_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 = p_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 = p_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 232: ben_per_in_ler pil

228: ecd.dpnt_person_id,
229: ecd.elig_per_elctbl_chc_id,
230: ecd.object_version_number
231: from ben_elig_cvrd_dpnt_f ecd,
232: ben_per_in_ler pil
233: where ecd.prtt_enrt_rslt_id = p_new_prtt_enrt_rslt_id
234: and ecd.cvg_strt_dt is not null
235: and nvl(ecd.cvg_thru_dt, hr_api.g_eot) = hr_api.g_eot
236: and ecd.business_group_id = p_business_group_id

Line 246: ben_per_in_ler pil

242: --
243: cursor old_bnf_c is
244: select pbn.*
245: from ben_pl_bnf_f pbn,
246: ben_per_in_ler pil
247: where pbn.prtt_enrt_rslt_id = p_old_prtt_enrt_rslt_id
248: and pbn.business_group_id = p_business_group_id
249: and p_effective_date between pbn.effective_start_date
250: and pbn.effective_end_date

Line 262: ben_per_in_ler pil,

258: v_grp_rlshp_cd varchar2 ) is
259: select count(old.elig_cvrd_dpnt_id)
260: from ben_elig_cvrd_dpnt_f old,
261: ben_elig_dpnt new,
262: ben_per_in_ler pil,
263: ben_per_in_ler pil2,
264: per_contact_relationships pcr
265: where old.prtt_enrt_rslt_id = p_old_prtt_enrt_rslt_id
266: and old.cvg_strt_dt is not null

Line 263: ben_per_in_ler pil2,

259: select count(old.elig_cvrd_dpnt_id)
260: from ben_elig_cvrd_dpnt_f old,
261: ben_elig_dpnt new,
262: ben_per_in_ler pil,
263: ben_per_in_ler pil2,
264: per_contact_relationships pcr
265: where old.prtt_enrt_rslt_id = p_old_prtt_enrt_rslt_id
266: and old.cvg_strt_dt is not null
267: and nvl(old.cvg_thru_dt, hr_api.g_eot) >= nvl(pil2.lf_evt_ocrd_dt - 1,