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 310: from ben_ptip_f ptip

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

Line 354: from ben_ptip_f ptip

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

Line 425: ben_ptip_f ptip

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