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_ELCT_CHC_FLX_IMP dependencies on BEN_OPTIP_F

Line 306: ben_optip_f otp,

302: --
303: cursor c_abr6 is
304: select abr.acty_base_rt_id, abr.cmbn_ptip_opt_id
305: from ben_acty_base_rt_f abr,
306: ben_optip_f otp,
307: ben_oipl_f oipl
308: where abr.acty_base_rt_stat_cd = 'A'
309: and abr.rt_usg_cd in ('FLXCR')
310: and abr.cmbn_ptip_opt_id = otp.cmbn_ptip_opt_id

Line 461: ben_optip_f otp,

457: select bpp.bnft_prvdr_pool_id,
458: bpp.cmbn_ptip_opt_id
459: from ben_bnft_prvdr_pool_f bpp,
460: ben_cmbn_ptip_opt_f cpt,
461: ben_optip_f otp,
462: ben_oipl_f oipl
463: where oipl.oipl_id = l_oipl_id
464: and otp.opt_id = oipl.opt_id
465: and otp.ptip_id = l_ptip_id