APPS.BEN_ABP_BUS dependencies on BEN_APLCN_TO_BNFT_POOL_F

Line 95: from ben_aplcn_to_bnft_pool_f

91: l_proc varchar2(72) := g_package||'chk_abr_dups';
92:
93: cursor c_abp is
94: select 'x'
95: from ben_aplcn_to_bnft_pool_f
96: where bnft_prvdr_pool_id = p_bnft_prvdr_pool_id
97: and acty_base_rt_id = p_acty_base_rt_id
98: and aplcn_to_bnft_pool_id <> nvl(p_aplcn_to_bnft_pool_id,-1)
99: and p_effective_date between effective_start_date

Line 462: ben_aplcn_to_bnft_pool_f b

458: --
459: cursor csr_leg_code is
460: select a.legislation_code
461: from per_business_groups a,
462: ben_aplcn_to_bnft_pool_f b
463: where b.aplcn_to_bnft_pool_id = p_aplcn_to_bnft_pool_id
464: and a.business_group_id = b.business_group_id;
465: --
466: -- Declare local variables