APPS.PER_ORG_STRUCTURE_ELEMENTS_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 408: from hr_all_organization_units org

404: select null
405: into l_temp
406: from sys.dual
407: where exists(select null
408: from hr_all_organization_units org
409: where org.organization_id = p_org_id_parent
410: and p_date_from between
411: org.date_from and nvl(org.date_to, p_end_of_time)
412: );