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

Line 205: from ben_ptip_f ptip

201: ptip.dpnt_cvg_strt_dt_cd,
202: ptip.dpnt_cvg_strt_dt_rl,
203: ptip.dpnt_cvg_end_dt_cd,
204: ptip.dpnt_cvg_end_dt_rl
205: from ben_ptip_f ptip
206: where ptip.ptip_id = l_ptip_id
207: and ptip.business_group_id = l_business_group_id
208: and nvl(l_per_in_ler.lf_evt_ocrd_dt,p_effective_date)
209: between nvl(ptip.effective_start_date,p_effective_date)

Line 690: from ben_ptip_f ptip

686: cursor c_ptip(l_pgm_id number) is
687: select ptip.ptip_id,
688: ptip.vrfy_fmly_mmbr_cd,
689: ptip.vrfy_fmly_mmbr_rl
690: from ben_ptip_f ptip
691: where ptip.business_group_id = p_business_group_id
692: and ptip.ptip_stat_cd = 'A'
693: and ptip.pgm_id = l_pgm_id
694: and p_effective_date