APPS.BEN_BPR_BUS dependencies on BEN_BNFT_POOL_RLOVR_RQMT_F

Line 1366: from ben_bnft_pool_rlovr_rqmt_f

1362: l_proc varchar2(72) := g_package||'chk_abr_dups';
1363:
1364: cursor c_abp is
1365: select 'x'
1366: from ben_bnft_pool_rlovr_rqmt_f
1367: where bnft_prvdr_pool_id = p_bnft_prvdr_pool_id
1368: and acty_base_rt_id = p_acty_base_rt_id
1369: and bnft_pool_rlovr_rqmt_id <> nvl(p_bnft_pool_rlovr_rqmt_id,-1)
1370: and p_effective_date between effective_start_date

Line 1936: ben_bnft_pool_rlovr_rqmt_f b

1932: --
1933: cursor csr_leg_code is
1934: select a.legislation_code
1935: from per_business_groups a,
1936: ben_bnft_pool_rlovr_rqmt_f b
1937: where b.bnft_pool_rlovr_rqmt_id = p_bnft_pool_rlovr_rqmt_id
1938: and a.business_group_id = b.business_group_id;
1939: --
1940: -- Declare local variables