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.HRI_OPL_BEN_DIM_REFRESH dependencies on BEN_PL_TYP_F

Line 132: FROM ben_ptip_f ctp, ben_pl_typ_f ptp

128: --
129: CURSOR c_ptip IS
130: SELECT ctp.ptip_id ptip_id, ctp.pl_typ_id pl_typ_id, ctp.pgm_id pgm_id,
131: ctp.ordr_num ptip_ordr_num
132: FROM ben_ptip_f ctp, ben_pl_typ_f ptp
133: WHERE ctp.pl_typ_id = ptp.pl_typ_id
134: AND l_effective_date BETWEEN ctp.effective_start_date
135: AND ctp.effective_end_date
136: AND l_effective_date BETWEEN ptp.effective_start_date

Line 643: FROM ben_ptip_f ctp, ben_pl_typ_f ptp

639: CURSOR c_ptip
640: IS
641: SELECT ctp.ptip_id ptip_id, ctp.pl_typ_id pl_typ_id, ctp.pgm_id pgm_id,
642: ctp.ordr_num ptip_ordr_num
643: FROM ben_ptip_f ctp, ben_pl_typ_f ptp
644: WHERE ctp.pl_typ_id = ptp.pl_typ_id
645: AND l_effective_date BETWEEN ctp.effective_start_date
646: AND ctp.effective_end_date
647: AND l_effective_date BETWEEN ptp.effective_start_date