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

6882: ptip.rt_strt_dt_cd,
6883: ptip.rt_strt_dt_rl,
6884: ptip.rt_end_dt_cd,
6885: ptip.rt_end_dt_rl
6886: from ben_ptip_f ptip
6887: where ptip.ptip_id=c_ptip_id
6888: and c_effective_date
6889: between ptip.effective_start_date and ptip.effective_end_date
6890: union

Line 7076: from ben_ptip_f ptip

7072: ptip.rt_strt_dt_cd,
7073: ptip.rt_strt_dt_rl,
7074: ptip.rt_end_dt_cd,
7075: ptip.rt_end_dt_rl
7076: from ben_ptip_f ptip
7077: where ptip.ptip_id=c_ptip_id
7078: and c_effective_date
7079: between ptip.effective_start_date and ptip.effective_end_date
7080: and ( enrt_cvg_strt_dt_cd is not null

Line 7175: from ben_ptip_f ptp,

7171: ,c_effective_date in date
7172: )
7173: is
7174: select ptp.ptip_id
7175: from ben_ptip_f ptp,
7176: ben_pl_f pln
7177: where ptp.pl_typ_id = pln.pl_typ_id
7178: and c_effective_date
7179: between pln.effective_start_date and pln.effective_end_date