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_BNFT_PRVDR_POOL_F

Line 339: from ben_bnft_prvdr_pool_f bpp

335:
336: -- Process Program Level Flex Credits
337: cursor c_bpp1 is
338: select bpp.bnft_prvdr_pool_id
339: from ben_bnft_prvdr_pool_f bpp
340: where bpp.pgm_id = l_pgm_id
341: --bug 2251364 if the other pool created first
342: --- this will create problem , pgm_id stored for
343: --- all the levels

Line 366: from ben_bnft_prvdr_pool_f bpp

362:
363: -- Process PLIP Level Flex Credits
364: cursor c_bpp2 is
365: select bpp.bnft_prvdr_pool_id
366: from ben_bnft_prvdr_pool_f bpp
367: where bpp.plip_id = l_plip_id
368: and nvl(p_lf_evt_ocrd_dt,p_effective_date)
369: between bpp.effective_start_date
370: and bpp.effective_end_date

Line 378: from ben_bnft_prvdr_pool_f bpp

374:
375: -- Process PTIP Level Flex Credits
376: cursor c_bpp3 is
377: select bpp.bnft_prvdr_pool_id
378: from ben_bnft_prvdr_pool_f bpp
379: where bpp.ptip_id = l_ptip_id
380: and nvl(p_lf_evt_ocrd_dt,p_effective_date)
381: between bpp.effective_start_date
382: and bpp.effective_end_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)

Line 411: from ben_bnft_prvdr_pool_f bpp,ben_cmbn_plip_f cpl, ben_plip_f cpp

407:
408: -- Process Combo PLIP Level Flex Credits
409: cursor c_bpp5 is
410: select bpp.bnft_prvdr_pool_id, bpp.cmbn_plip_id
411: from ben_bnft_prvdr_pool_f bpp,ben_cmbn_plip_f cpl, ben_plip_f cpp
412: where cpp.plip_id = l_plip_id
413: and cpp.cmbn_plip_id = cpl.cmbn_plip_id
414: and bpp.cmbn_plip_id = cpl.cmbn_plip_id
415: and nvl(p_lf_evt_ocrd_dt,p_effective_date)

Line 432: from ben_bnft_prvdr_pool_f bpp,ben_cmbn_ptip_opt_f cpt, ben_opt_f opt,

428: -- Process Combo PTIP Option Level Flex Credits
429: /* bug 1285336
430: cursor c_bpp6 is
431: select bpp.bnft_prvdr_pool_id, bpp.cmbn_ptip_opt_id
432: from ben_bnft_prvdr_pool_f bpp,ben_cmbn_ptip_opt_f cpt, ben_opt_f opt,
433: ben_oipl_f oipl
434: where oipl.oipl_id = l_oipl_id
435: and opt.opt_id = oipl.opt_id
436: and cpt.ptip_id = l_ptip_id

Line 459: from ben_bnft_prvdr_pool_f bpp,

455:
456: cursor c_bpp6 is
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

Line 487: from ben_bnft_prvdr_pool_f bpp

483:
484: -- Process OIPLIP Level Flex Credits
485: cursor c_bpp7 is
486: select bpp.bnft_prvdr_pool_id
487: from ben_bnft_prvdr_pool_f bpp
488: where bpp.oiplip_id = l_oiplip_id
489: and nvl(p_lf_evt_ocrd_dt,p_effective_date)
490: between bpp.effective_start_date
491: and bpp.effective_end_date