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 561: if ((hr_organization_units_pkg.exists_in_hierarchy(p_org_structure_version_id

557: check_org_active(p_Organization_Id_Parent,
558: p_date_from
559: ,p_end_of_time
560: ,p_warning_raised => p_warning_raised);
561: if ((hr_organization_units_pkg.exists_in_hierarchy(p_org_structure_version_id
562: ,p_organization_id_child) = 'Y')) then
563: --
564: -- Yes , then merely update the old structure element
565: --