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

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

Line 687: from ben_ptip_f ptip

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