APPS.BEN_BPP_BUS dependencies on BEN_COMP_LVL_FCTR

Line 1334: from ben_comp_lvl_fctr a

1330: l_dummy varchar2(1);
1331: --
1332: cursor c1 is
1333: select null
1334: from ben_comp_lvl_fctr a
1335: where a.comp_lvl_fctr_id = p_comp_lvl_fctr_id;
1336: --
1337: Begin
1338: --

Line 1352: -- check if comp_lvl_fctr_id value exists in ben_comp_lvl_fctr table

1348: <> nvl(ben_bpp_shd.g_old_rec.comp_lvl_fctr_id,hr_api.g_number)
1349: or not l_api_updating)
1350: and p_comp_lvl_fctr_id is not null then
1351: --
1352: -- check if comp_lvl_fctr_id value exists in ben_comp_lvl_fctr table
1353: --
1354:
1355: --
1356: -- check if comp_lvl_fctr_id value exists in ben_comp_lvl_fctr table

Line 1356: -- check if comp_lvl_fctr_id value exists in ben_comp_lvl_fctr table

1352: -- check if comp_lvl_fctr_id value exists in ben_comp_lvl_fctr table
1353: --
1354:
1355: --
1356: -- check if comp_lvl_fctr_id value exists in ben_comp_lvl_fctr table
1357: --
1358: open c1;
1359: --
1360: fetch c1 into l_dummy;

Line 1365: -- raise error as FK does not relate to PK in ben_comp_lvl_fctr

1361: if c1%notfound then
1362: --
1363: close c1;
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: --