DBA Data[Home] [Help]

APPS.PQH_CET_BUS dependencies on PER_BUSINESS_GROUPS

Line 274: from per_business_groups a

270: l_dummy varchar2(1);
271: --
272: cursor c1 is
273: select null
274: from per_business_groups a
275: where a.business_group_id = p_context_business_group_id;
276: --
277: Begin
278: --

Line 290: -- check if context_business_group_id value exists in per_business_groups table

286: and nvl(p_context_business_group_id,hr_api.g_number)
287: <> nvl(pqh_cet_shd.g_old_rec.context_business_group_id,hr_api.g_number)
288: or not l_api_updating) then
289: --
290: -- check if context_business_group_id value exists in per_business_groups table
291: --
292: open c1;
293: --
294: fetch c1 into l_dummy;

Line 299: -- raise error as FK does not relate to PK in per_business_groups

295: if c1%notfound then
296: --
297: close c1;
298: --
299: -- raise error as FK does not relate to PK in per_business_groups
300: -- table.
301: --
302: pqh_cet_shd.constraint_error('PQH_COPY_ENTITY_TXNS_FK2');
303: --