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.

[Home] [Help]

APPS.BEN_DET_ENRT_RATES dependencies on BEN_BNFT_POOL_RLOVR_RQMT_F

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

364: pil.per_in_ler_id = pel.per_in_ler_id and
365: pel.pil_elctbl_chc_popl_id = epe.pil_elctbl_chc_popl_id and
366: epe.business_group_id=p_business_group_id and
367: epe.elig_per_elctbl_chc_id=ecr2.elig_per_elctbl_chc_id(+) and
368: bpp.bnft_prvdr_pool_id in (select bnft_prvdr_pool_id from ben_bnft_pool_rlovr_rqmt_f
369: where business_group_id=p_business_group_id
370: and p_effective_date between effective_start_date and effective_end_date) and
371: bpp.business_group_id = p_business_group_id and --
372: p_effective_date between bpp.effective_start_date and bpp.effective_end_date and --

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

370: and p_effective_date between effective_start_date and effective_end_date) and
371: bpp.business_group_id = p_business_group_id and --
372: p_effective_date between bpp.effective_start_date and bpp.effective_end_date and --
373: bpp.pgm_id = epe.pgm_id and --
374: (ecr1.acty_base_rt_id in (select acty_base_rt_id from ben_bnft_pool_rlovr_rqmt_f
375: where business_group_id=p_business_group_id
376: and p_effective_date between effective_start_date and effective_end_date) or
377: ecr2.acty_base_rt_id in (select acty_base_rt_id from ben_bnft_pool_rlovr_rqmt_f
378: where business_group_id=p_business_group_id

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

373: bpp.pgm_id = epe.pgm_id and --
374: (ecr1.acty_base_rt_id in (select acty_base_rt_id from ben_bnft_pool_rlovr_rqmt_f
375: where business_group_id=p_business_group_id
376: and p_effective_date between effective_start_date and effective_end_date) or
377: ecr2.acty_base_rt_id in (select acty_base_rt_id from ben_bnft_pool_rlovr_rqmt_f
378: where business_group_id=p_business_group_id
379: and p_effective_date between effective_start_date and effective_end_date)) and
380: pen.prtt_enrt_rslt_id(+)=epe.prtt_enrt_rslt_id and
381: epe.elig_per_elctbl_chc_id=enb.elig_per_elctbl_chc_id(+) and