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_PTIP_F

Line 228: ben_ptip_f ptip

224: cursor c_abr4 is
225: select abr.acty_base_rt_id, abr.cmbn_ptip_id
226: from ben_acty_base_rt_f abr,
227: ben_cmbn_ptip_f cptip,
228: ben_ptip_f ptip
229: where abr.acty_base_rt_stat_cd = 'A'
230: and abr.rt_usg_cd in ('FLXCR')
231: --and abr.cmbn_ptip_id = l_cmbn_ptip_id
232: and nvl(p_lf_evt_ocrd_dt,p_effective_date)

Line 391: from ben_bnft_prvdr_pool_f bpp,ben_cmbn_ptip_f cbp,ben_ptip_f ctp

387:
388: -- Process Combo PTIP Level Flex Credits
389: cursor c_bpp4 is
390: select bpp.bnft_prvdr_pool_id, bpp.cmbn_ptip_id
391: from ben_bnft_prvdr_pool_f bpp,ben_cmbn_ptip_f cbp,ben_ptip_f ctp
392: where ctp.ptip_id = l_ptip_id
393: and ctp.cmbn_ptip_id = cbp.cmbn_ptip_id
394: and bpp.cmbn_ptip_id = cbp.cmbn_ptip_id
395: and nvl(p_lf_evt_ocrd_dt,p_effective_date)