APPS.BEN_DETERMINE_ACTIVITY_BASE_RT dependencies on BEN_APLCN_TO_BNFT_POOL_F
Line 864: from ben_aplcn_to_bnft_pool_f abp
860: (c_effective_date in date
861: )
862: is
863: select abp.bnft_prvdr_pool_id 864: from ben_aplcn_to_bnft_pool_f abp 865: where abp.acty_base_rt_id = p_acty_base_rt_id
866: and c_effective_date
867: between abp.effective_start_date
868: and abp.effective_end_date