APPS.PER_ORG_STRUCTURE_ELEMENTS_PKG dependencies on HR_ORGANIZATION_UNITS

Line 26: from hr_organization_units hru

22: from per_org_structure_elements ose
23: where ((nvl(p_view_all_orgs,'Y') <> 'Y'
24: and EXISTS
25: (select '1'
26: from hr_organization_units hru
27: where hru.organization_id = ose.organization_id_child
28: ))
29: or nvl(p_view_all_orgs,'Y') = 'Y')
30: connect by

Line 595: if ((hr_organization_units_pkg.exists_in_hierarchy(p_org_structure_version_id

591: check_org_active(p_Organization_Id_Parent,
592: p_date_from
593: ,p_end_of_time
594: ,p_warning_raised => p_warning_raised);
595: if ((hr_organization_units_pkg.exists_in_hierarchy(p_org_structure_version_id
596: ,p_organization_id_child) = 'Y')) then
597: --
598: -- Yes , then merely update the old structure element
599: --