DBA Data[Home] [Help]

APPS.PER_ASG_BUS3 dependencies on HR_ALL_ORGANIZATION_UNITS

Line 551: from hr_all_organization_units hou

547: --
548:
549: cursor csr_estab_in_org_units is
550: select null
551: from hr_all_organization_units hou
552: where hou.organization_id = p_establishment_id
553: and hou.business_group_id = p_business_group_id
554: and p_effective_date between date_from and nvl(date_to, p_effective_date);
555: --