DBA Data[Home] [Help]

APPS.BEN_ECL_BUS dependencies on BEN_COMP_LVL_FCTR

Line 133: from ben_comp_lvl_fctr a

129: --
130: --
131: cursor c1 is
132: select null
133: from ben_comp_lvl_fctr a
134: where a.comp_lvl_fctr_id = p_comp_lvl_fctr_id;
135: --
136: Begin
137: --

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

146: and nvl(p_comp_lvl_fctr_id,hr_api.g_number)
147: <> nvl(ben_ecl_shd.g_old_rec.comp_lvl_fctr_id,hr_api.g_number)
148: or not l_api_updating) then
149: --
150: -- check if comp_lvl_fctr_id value exists in ben_comp_lvl_fctr table
151: --
152: open c1;
153: --
154: fetch c1 into l_dummy;

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

155: if c1%notfound then
156: --
157: close c1;
158: --
159: -- raise error as FK does not relate to PK in ben_comp_lvl_fctr
160: -- table.
161: --
162: ben_ecl_shd.constraint_error('BEN_ELIG_COMP_LVL_FK1');
163: --