DBA Data[Home] [Help]

APPS.BEN_PDL_BUS dependencies on PAY_BALANCE_TYPES

Line 267: from pay_balance_types a

263: l_dummy varchar2(1);
264: --
265: cursor c1 is
266: select null
267: from pay_balance_types a
268: where a.balance_type_id = p_balance_type_id;
269: --
270: Begin
271: --

Line 285: -- check if balance_type_id value exists in pay_balance_types table

281: <> nvl(ben_pdl_shd.g_old_rec.balance_type_id,hr_api.g_number)
282: or not l_api_updating) and
283: p_balance_type_id is not null then
284: --
285: -- check if balance_type_id value exists in pay_balance_types table
286: --
287: open c1;
288: --
289: fetch c1 into l_dummy;

Line 294: -- raise error as FK does not relate to PK in pay_balance_types

290: if c1%notfound then
291: --
292: close c1;
293: --
294: -- raise error as FK does not relate to PK in pay_balance_types
295: -- table.
296: --
297: fnd_message.set_name('BEN','BEN_91770_BAL_TYPE_NOT_EXIST');
298: fnd_message.raise_error;