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

Line 7065: from ben_ptip_f ptip

7061: ptip.rt_strt_dt_cd,
7062: ptip.rt_strt_dt_rl,
7063: ptip.rt_end_dt_cd,
7064: ptip.rt_end_dt_rl
7065: from ben_ptip_f ptip
7066: where ptip.ptip_id=c_ptip_id
7067: and c_effective_date
7068: between ptip.effective_start_date and ptip.effective_end_date
7069: union

Line 7255: from ben_ptip_f ptip

7251: ptip.rt_strt_dt_cd,
7252: ptip.rt_strt_dt_rl,
7253: ptip.rt_end_dt_cd,
7254: ptip.rt_end_dt_rl
7255: from ben_ptip_f ptip
7256: where ptip.ptip_id=c_ptip_id
7257: and c_effective_date
7258: between ptip.effective_start_date and ptip.effective_end_date
7259: and ( enrt_cvg_strt_dt_cd is not null

Line 7354: from ben_ptip_f ptp,

7350: ,c_effective_date in date
7351: )
7352: is
7353: select ptp.ptip_id
7354: from ben_ptip_f ptp,
7355: ben_pl_f pln
7356: where ptp.pl_typ_id = pln.pl_typ_id
7357: and c_effective_date
7358: between pln.effective_start_date and pln.effective_end_date