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 PER_CONTACT_RELATIONSHIPS

Line 139: per_contact_relationships pcr,

135: select old.elig_cvrd_dpnt_id old_dpnt,
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

Line 179: per_contact_relationships pcr2

175: and p.effective_end_date
176: and nvl(p.mx_dpnts_alwd_num,999) >=
177: (select count('s')
178: from ben_elig_dpnt new2,
179: per_contact_relationships pcr2
180: where new2.elig_per_elctbl_chc_id = p_new_elig_per_elctbl_chc_id
181: and new2.business_group_id = p_business_group_id
182: and new2.dpnt_person_id in
183: -- Make sure that the dpnt being counted was covered before

Line 264: per_contact_relationships pcr

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,
268: hr_api.g_eot)