DBA Data[Home] [Help]

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