DBA Data[Home] [Help]

APPS.BEN_DETERMINE_RATE_CHG dependencies on BEN_BNFT_PRVDR_POOL_F

Line 2480: from ben_elig_per_elctbl_chc epe, ben_BNFT_PRVDR_POOL_f bpl,

2476: where ecr.acty_base_rt_id = p_acty_base_rt_id
2477: and ecr.elig_per_elctbl_chc_id in
2478: (select
2479: epe.elig_per_elctbl_chc_id
2480: from ben_elig_per_elctbl_chc epe, ben_BNFT_PRVDR_POOL_f bpl,
2481: ben_acty_base_rt_f abr
2482: where epe.BNFT_PRVDR_POOL_ID = p_bnft_prvdr_pool_id
2483: and epe.bnft_prvdr_pool_id = bpl.bnft_prvdr_pool_id
2484: and p_effective_date between bpl.effective_start_date and