APPS.HR_PERF_MGMT_PLAN_INTERNAL dependencies on HR_ORGANIZATION_UNITS

Line 831: hr_organization_units org

827: AND o.org_structure_version_id = p_plan_rec.org_structure_version_id
828: UNION
829: SELECT p_plan_rec.top_organization_id organization_id_child
830: FROM DUAL) o,
831: hr_organization_units org
832: WHERE o.organization_id_child = org.organization_id
833: AND p_effective_date BETWEEN org.date_from AND NVL (org.date_to, p_effective_date));
834:
835: -- Position Hierarchy population