APPS.PER_OSE_BUS dependencies on HR_ALL_ORGANIZATION_UNITS

Line 512: -- exist in hr_all_organization_units for the business group (if not global)

508: -- |-------------------< chk_parent_child_org_id >------------------------|
509: -- -----------------------------------------------------------------------------
510: -- Description:
511: -- Validates that both the parent and subordinate orgs are supplied and
512: -- exist in hr_all_organization_units for the business group (if not global)
513: -- on the effective_date.
514: -- Also checks that the subordinate org is unique within the structure
515: -- version, to prevent circular hierarchies. (Insert Only).
516: --

Line 547: from hr_all_organization_units org

543: ,p_organization_id_child in NUMBER) IS
544:
545: CURSOR csr_org (p_org_id in NUMBER) IS
546: SELECT 'X'
547: from hr_all_organization_units org
548: where org.organization_id = p_org_id
549: and (org.business_group_id = p_business_group_id
550: or p_business_group_id is null)
551: and p_effective_date between org.DATE_FROM