DBA Data[Home] [Help]

APPS.HR_PERF_MGMT_PLAN_INTERNAL dependencies on HR_ORGANIZATION_UNITS

Line 533: SELECT p_plan_rec.top_organization_id organization_id_child from dual) o, hr_organization_units org

529: AND LEVEL <= NVL(p_plan_rec.hierarchy_levels, LEVEL)
530: START WITH o.organization_id_parent = p_plan_rec.top_organization_id
531: AND o.org_structure_version_id = p_plan_rec.org_structure_version_id
532: UNION
533: SELECT p_plan_rec.top_organization_id organization_id_child from dual) o, hr_organization_units org
534: where o.organization_id_child = org.organization_id
535: and p_effective_date between org.date_from and nvl(org.date_to, p_effective_date));
536:
537: