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_ELIG_PER_ELCTBL_CHC

Line 173: ben_elig_per_elctbl_chc epe

169: )) --'Y'
170: and old.cvg_thru_dt <> hr_api.g_eot
171: and ('Y' = (select 'Y' from dual where exists
172: (select '1' from ben_elig_dpnt edp,
173: ben_elig_per_elctbl_chc epe
174: where edp.dpnt_person_id = old.dpnt_person_id
175: and edp.per_in_ler_id = new.per_in_ler_id
176: and epe.prtt_enrt_rslt_id = p_old_prtt_enrt_rslt_id
177: and epe.per_in_ler_id = new.per_in_ler_id

Line 218: and pen5.pl_typ_id in (select pl_typ_id from ben_elig_per_elctbl_chc

214: and pen5.per_in_ler_id = ben_manage_life_events.g_bckdt_per_in_ler_id
215: and pen5.prtt_enrt_rslt_id <> l_old_prtt_enrt_rslt_id
216: and pen5.business_group_id = p_business_group_id
217: and pen5.prtt_enrt_rslt_id = pdp_old.prtt_enrt_rslt_id
218: and pen5.pl_typ_id in (select pl_typ_id from ben_elig_per_elctbl_chc
219: where elig_per_elctbl_chc_id = p_new_elig_per_elctbl_chc_id)
220: union
221: select '1' from ben_elig_cvrd_dpnt_f pdp_old
222: ,ben_prtt_enrt_rslt_f pen5

Line 232: and pen5.pl_typ_id in (select pl_typ_id from ben_elig_per_elctbl_chc

228: and pen5.per_in_ler_id = ben_manage_life_events.g_bckdt_per_in_ler_id
229: and pen5.prtt_enrt_rslt_id <> l_old_prtt_enrt_rslt_id
230: and pen5.business_group_id = p_business_group_id
231: and pen5.prtt_enrt_rslt_id = pdp_old.prtt_enrt_rslt_id
232: and pen5.pl_typ_id in (select pl_typ_id from ben_elig_per_elctbl_chc
233: where elig_per_elctbl_chc_id = p_new_elig_per_elctbl_chc_id) )))
234:
235: )
236: )