APPS.BEN_CLF_BUS dependencies on BEN_COMP_LVL_FCTR

Line 56: ben_clf_shd.constraint_error('BEN_COMP_LVL_FCTR_PK');

52: <> ben_clf_shd.g_old_rec.comp_lvl_fctr_id) then
53: --
54: -- raise error as PK has changed
55: --
56: ben_clf_shd.constraint_error('BEN_COMP_LVL_FCTR_PK');
57: --
58: elsif not l_api_updating then
59: --
60: -- check if PK is null

Line 66: ben_clf_shd.constraint_error('BEN_COMP_LVL_FCTR_PK');

62: if p_comp_lvl_fctr_id is not null then
63: --
64: -- raise error as PK is not null
65: --
66: ben_clf_shd.constraint_error('BEN_COMP_LVL_FCTR_PK');
67: --
68: end if;
69: --
70: end if;

Line 140: ben_clf_shd.constraint_error('BEN_COMP_LVL_FCTR_FK2');

136: if c1%notfound then
137: --
138: close c1;
139: --
140: ben_clf_shd.constraint_error('BEN_COMP_LVL_FCTR_FK2');
141: --
142: end if;
143: --
144: close c1;

Line 1071: from ben_comp_lvl_fctr clf

1067: l_dummy varchar2(1);
1068: --
1069: cursor c1 is
1070: select null
1071: from ben_comp_lvl_fctr clf
1072: where clf.business_group_id = p_business_group_id and
1073: clf.name = p_name;
1074: Begin
1075: --

Line 1386: -- ben_comp_lvl_fctr table.

1382: --
1383: -- Description
1384: -- This procedure is used to check that compensation level factor child records
1385: -- do not exist when the user deletes the record in the
1386: -- ben_comp_lvl_fctr table.
1387: --
1388: -- Pre Conditions
1389: -- None.
1390: --

Line 1788: ben_comp_lvl_fctr b

1784: --
1785: cursor csr_leg_code is
1786: select a.legislation_code
1787: from per_business_groups a,
1788: ben_comp_lvl_fctr b
1789: where b.comp_lvl_fctr_id = p_comp_lvl_fctr_id
1790: and a.business_group_id = b.business_group_id;
1791: --
1792: -- Declare local variables