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_DET_ENRT_RATES dependencies on BEN_BNFT_POOL_RLOVR_RQMT_F

Line 124: from ben_bnft_pool_rlovr_rqmt_f rlovr,

120: --Bug 9775905
121: or (c_enrt_mthd_cd = 'D' and
122: pen.enrt_mthd_cd = 'E' and
123: exists (select null
124: from ben_bnft_pool_rlovr_rqmt_f rlovr,
125: ben_prtt_enrt_rslt_f pen1,
126: ben_bnft_prvdd_ldgr_f ldgr,
127: ben_acty_base_rt_f abr
128: where pen1.pgm_id = pen.pgm_id

Line 412: bpp.bnft_prvdr_pool_id in (select bnft_prvdr_pool_id from ben_bnft_pool_rlovr_rqmt_f

408: pil.per_in_ler_id = pel.per_in_ler_id and
409: pel.pil_elctbl_chc_popl_id = epe.pil_elctbl_chc_popl_id and
410: epe.business_group_id=p_business_group_id and
411: epe.elig_per_elctbl_chc_id=ecr2.elig_per_elctbl_chc_id(+) and
412: bpp.bnft_prvdr_pool_id in (select bnft_prvdr_pool_id from ben_bnft_pool_rlovr_rqmt_f
413: where business_group_id=p_business_group_id
414: and p_effective_date between effective_start_date and effective_end_date) and
415: bpp.business_group_id = p_business_group_id and --
416: p_effective_date between bpp.effective_start_date and bpp.effective_end_date and --

Line 418: (ecr1.acty_base_rt_id in (select acty_base_rt_id from ben_bnft_pool_rlovr_rqmt_f

414: and p_effective_date between effective_start_date and effective_end_date) and
415: bpp.business_group_id = p_business_group_id and --
416: p_effective_date between bpp.effective_start_date and bpp.effective_end_date and --
417: bpp.pgm_id = epe.pgm_id and --
418: (ecr1.acty_base_rt_id in (select acty_base_rt_id from ben_bnft_pool_rlovr_rqmt_f
419: where business_group_id=p_business_group_id
420: and p_effective_date between effective_start_date and effective_end_date) or
421: ecr2.acty_base_rt_id in (select acty_base_rt_id from ben_bnft_pool_rlovr_rqmt_f
422: where business_group_id=p_business_group_id

Line 421: ecr2.acty_base_rt_id in (select acty_base_rt_id from ben_bnft_pool_rlovr_rqmt_f

417: bpp.pgm_id = epe.pgm_id and --
418: (ecr1.acty_base_rt_id in (select acty_base_rt_id from ben_bnft_pool_rlovr_rqmt_f
419: where business_group_id=p_business_group_id
420: and p_effective_date between effective_start_date and effective_end_date) or
421: ecr2.acty_base_rt_id in (select acty_base_rt_id from ben_bnft_pool_rlovr_rqmt_f
422: where business_group_id=p_business_group_id
423: and p_effective_date between effective_start_date and effective_end_date)) and
424: pen.prtt_enrt_rslt_id(+)=epe.prtt_enrt_rslt_id and
425: epe.elig_per_elctbl_chc_id=enb.elig_per_elctbl_chc_id(+) and