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_EFC_ADJUSTMENTS1 dependencies on BEN_ACTY_VRBL_RT_F

Line 464: , ben_acty_vrbl_rt_f avr

460: abr.oipl_id,
461: abr.oiplip_id,
462: abr.nnmntry_uom
463: FROM ben_vrbl_rt_prfl_f vpf
464: , ben_acty_vrbl_rt_f avr
465: , ben_acty_base_rt_f abr
466: WHERE avr.vrbl_rt_prfl_id = c_vpf_id
467: AND vpf.VRBL_USG_CD = 'RT'
468: AND vpf.vrbl_rt_prfl_id = avr.vrbl_rt_prfl_id

Line 476: from ben_acty_vrbl_rt_f avr1,

472: AND c_eff_date
473: BETWEEN abr.effective_start_date AND abr.effective_end_date
474: AND avr.acty_base_rt_id =
475: (select min(avr1.acty_base_rt_id)
476: from ben_acty_vrbl_rt_f avr1,
477: ben_acty_base_rt_f abr1
478: where avr1.vrbl_rt_prfl_id = avr.vrbl_rt_prfl_id
479: AND vpf.effective_start_date
480: BETWEEN avr1.effective_start_date AND avr1.effective_end_date

Line 487: from ben_acty_vrbl_rt_f avr2,

483: BETWEEN abr1.effective_start_date AND abr1.effective_end_date
484: and abr1.NNMNTRY_UOM is null
485: and avr1.ordr_num =
486: (select min(avr2.ordr_num)
487: from ben_acty_vrbl_rt_f avr2,
488: ben_acty_base_rt_f abr2
489: where avr2.vrbl_rt_prfl_id = avr.vrbl_rt_prfl_id
490: AND vpf.effective_start_date
491: BETWEEN avr2.effective_start_date AND avr2.effective_end_date