DBA Data[Home] [Help]

APPS.BEN_PDL_BUS dependencies on BEN_COMP_LVL_FCTR

Line 188: from ben_comp_lvl_fctr a

184: l_dummy varchar2(1);
185: --
186: cursor c1 is
187: select null
188: from ben_comp_lvl_fctr a
189: where a.comp_lvl_fctr_id = p_comp_lvl_fctr_id;
190: --
191: Begin
192: --

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

202: <> nvl(ben_pdl_shd.g_old_rec.comp_lvl_fctr_id,hr_api.g_number)
203: or not l_api_updating) and
204: p_comp_lvl_fctr_id is not null then
205: --
206: -- check if comp_lvl_fctr_id value exists in ben_comp_lvl_fctr table
207: --
208: open c1;
209: --
210: fetch c1 into l_dummy;

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

211: if c1%notfound then
212: --
213: close c1;
214: --
215: -- raise error as FK does not relate to PK in ben_comp_lvl_fctr
216: -- table.
217: --
218: ben_pdl_shd.constraint_error('BEN_PTD_LMT_F_FK2');
219: --