APPS.PER_ESA_BUS dependencies on PER_ESTABLISHMENTS

Line 513: -- must exist in the per_establishments table.

509: --
510: -- Description
511: -- This procedure is used to check that either the establishment_id or the
512: -- establishment is populated. If the establishment id is populated then it
513: -- must exist in the per_establishments table.
514: --
515: -- Pre Conditions
516: -- None.
517: --

Line 545: from per_establishments per

541: l_dummy varchar2(1);
542: --
543: cursor c1 is
544: select null
545: from per_establishments per
546: where per.establishment_id = p_establishment_id;
547: --
548: Begin
549: --

Line 576: -- exist in per_establishments table.

572: --
573: end if;
574: --
575: -- check if establishment id has changed and if so does the establishment
576: -- exist in per_establishments table.
577: --
578: if p_establishment_id is not null
579: and (not l_api_updating
580: or (l_api_updating

Line 584: -- check if establishment id exists in per_establishments table

580: or (l_api_updating
581: and nvl(p_establishment_id,hr_api.g_number)
582: <> per_esa_shd.g_old_rec.establishment_id)) then
583: --
584: -- check if establishment id exists in per_establishments table
585: --
586: open c1;
587: --
588: fetch c1 into l_dummy;