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