DBA Data[Home] [Help]

APPS.PER_EVT_BUS dependencies on HR_ALL_ORGANIZATION_UNITS

Line 762: l_business_group_id hr_all_organization_units.business_group_id%type;

758: is
759: --
760: l_proc varchar2(72) := g_package||'chk_organization_run_by_id';
761: --
762: l_business_group_id hr_all_organization_units.business_group_id%type;
763: --
764: cursor csr_valid_org is
765: select business_group_id
766: from hr_all_organization_units hou

Line 766: from hr_all_organization_units hou

762: l_business_group_id hr_all_organization_units.business_group_id%type;
763: --
764: cursor csr_valid_org is
765: select business_group_id
766: from hr_all_organization_units hou
767: where hou.organization_id = p_organization_run_by_id
768: and p_date_start between date_from and nvl(date_to, hr_api.g_eot);
769: --
770: begin