APPS.BEN_BPP_BUS dependencies on BEN_BNFT_PRVDR_POOL_F

Line 117: from ben_bnft_prvdr_pool_f a

113: l_proc varchar2(72) := g_package||'chk_name_unique';
114: l_dummy char(1);
115: l_api_updating boolean;
116: cursor c1 is select null
117: from ben_bnft_prvdr_pool_f a
118: Where a.bnft_prvdr_pool_id <> nvl(p_bnft_prvdr_pool_id,hr_api.g_number)
119: and a.name = p_name
120: and a.business_group_id + 0 = p_business_group_id
121: and p_effective_date

Line 1368: ben_bpp_shd.constraint_error('BEN_BNFT_PRVDR_POOL_F_FK2');

1364: --
1365: -- raise error as FK does not relate to PK in ben_comp_lvl_fctr
1366: -- table.
1367: --
1368: ben_bpp_shd.constraint_error('BEN_BNFT_PRVDR_POOL_F_FK2');
1369: --
1370: end if;
1371: --
1372: close c1;

Line 2623: ben_bnft_prvdr_pool_f b

2619: --
2620: cursor csr_leg_code is
2621: select a.legislation_code
2622: from per_business_groups a,
2623: ben_bnft_prvdr_pool_f b
2624: where b.bnft_prvdr_pool_id = p_bnft_prvdr_pool_id
2625: and a.business_group_id = b.business_group_id;
2626: --
2627: -- Declare local variables