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_ELIG_CVRD_DPNT_API dependencies on BEN_DSGN_RQMT_RLSHP_TYP

Line 2812: ben_dsgn_rqmt_rlshp_typ dr

2808: ,r.dsgn_rqmt_id
2809: ,decode(oipl_id, null, decode(opt_id, null, 3, 2), 1) heir
2810: ,r.grp_rlshp_cd
2811: from ben_dsgn_rqmt_f r,
2812: ben_dsgn_rqmt_rlshp_typ dr
2813: where ((nvl(pl_id, hr_api.g_number) = cv_pl_id)
2814: or (nvl(oipl_id, hr_api.g_number) = cv_oipl_id)
2815: or (nvl(opt_id, hr_api.g_number) = cv_opt_id))
2816: and r.dsgn_typ_cd = 'DPNT'

Line 2877: from ben_dsgn_rqmt_rlshp_typ

2873: and d.effective_end_date = hr_api.g_eot -- bug 1237204
2874: and d.business_group_id + 0 = p_business_group_id
2875: and c.contact_type in
2876: (select rlshp_typ_cd
2877: from ben_dsgn_rqmt_rlshp_typ
2878: where dsgn_rqmt_id = l_dsgn_rqmt_id)
2879: and d.per_in_ler_id = pil.per_in_ler_id
2880: and pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT')
2881: ;