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_DETERMINE_DPNT_ELIGIBILITY dependencies on BEN_PTIP_F

Line 308: from ben_ptip_f ptip

304: --- This cursor added to find the pl_typ id # 2508745
305: --- for the ptip comparison for different pgm pl_typ_id to be compared
306: cursor c_pl_typ is
307: select pl_typ_id
308: from ben_ptip_f ptip
309: where p_ptip_id = ptip.ptip_id
310: and l_lf_evt_ocrd_dt
311: between ptip.effective_start_date
312: and ptip.effective_end_date ;

Line 352: from ben_ptip_f ptip

348: ptip.dpnt_cvg_strt_dt_cd,
349: ptip.dpnt_cvg_strt_dt_rl,
350: ptip.dpnt_cvg_end_dt_cd,
351: ptip.dpnt_cvg_end_dt_rl
352: from ben_ptip_f ptip
353: where ptip.ptip_id = p_ptip_id
354: and ptip.business_group_id = p_business_group_id
355: and l_lf_evt_ocrd_dt
356: between ptip.effective_start_date

Line 423: ben_ptip_f ptip

419: chg.cvg_eff_end_rl,
420: chg.ler_chg_dpnt_cvg_cd,
421: chg.ler_chg_dpnt_cvg_rl
422: from ben_ler_chg_dpnt_cvg_f chg,
423: ben_ptip_f ptip
424: where chg.ler_id = l_per_in_ler.ler_id
425: and chg.business_group_id = p_business_group_id
426: and chg.Ptip_id = ptip.ptip_id (+)
427: and l_lf_evt_ocrd_dt