DBA Data[Home] [Help]

APPS.PER_RAA_BUS dependencies on HR_ALL_ORGANIZATION_UNITS

Line 556: -- Checks that run_by_organization_id exists in HR_ALL_ORGANIZATION_UNITS

552: -- |--------------------< chk_run_by_organization_id >-------------------------|
553: -- -----------------------------------------------------------------------------
554: --
555: -- Description:
556: -- Checks that run_by_organization_id exists in HR_ALL_ORGANIZATION_UNITS
557: --
558: -- Prerequisites:
559: -- g_old_rec has been populated with details of the values currently in
560: -- the database.

Line 593: select null from HR_ALL_ORGANIZATION_UNITS hao

589: l_run_by_organization_id varchar2(1);
590: l_api_updating boolean;
591:
592: cursor csr_run_by_organization_id is
593: select null from HR_ALL_ORGANIZATION_UNITS hao
594: where hao.organization_id = p_run_by_organization_id;
595: --
596: begin
597: hr_utility.set_location('Entering:'||l_proc,10);