DBA Data[Home] [Help]

APPS.BEN_DETERMINE_RATE_CHG dependencies on BEN_BNFT_PRVDR_POOL_F

Line 2663: from ben_elig_per_elctbl_chc epe, ben_BNFT_PRVDR_POOL_f bpl,

2659: where ecr.acty_base_rt_id = p_acty_base_rt_id
2660: and ecr.elig_per_elctbl_chc_id in
2661: (select
2662: epe.elig_per_elctbl_chc_id
2663: from ben_elig_per_elctbl_chc epe, ben_BNFT_PRVDR_POOL_f bpl,
2664: ben_acty_base_rt_f abr
2665: where epe.BNFT_PRVDR_POOL_ID = p_bnft_prvdr_pool_id
2666: and epe.bnft_prvdr_pool_id = bpl.bnft_prvdr_pool_id
2667: and p_effective_date between bpl.effective_start_date and