DBA Data[Home] [Help]

APPS.BEN_DETERMINE_ACTIVITY_BASE_RT dependencies on BEN_APLCN_TO_BNFT_POOL_F

Line 881: from ben_aplcn_to_bnft_pool_f abp

877: (c_effective_date in date
878: )
879: is
880: select abp.bnft_prvdr_pool_id
881: from ben_aplcn_to_bnft_pool_f abp
882: where abp.acty_base_rt_id = p_acty_base_rt_id
883: and c_effective_date
884: between abp.effective_start_date
885: and abp.effective_end_date