DBA Data[Home] [Help]

APPS.HR_PERF_MGMT_PLAN_INTERNAL dependencies on PER_ORG_STRUCTURE_ELEMENTS

Line 822: FROM per_org_structure_elements o

818: ))
819: AND asg.organization_id IN (
820: SELECT o.organization_id_child
821: FROM (SELECT o.organization_id_child
822: FROM per_org_structure_elements o
823: CONNECT BY o.organization_id_parent = PRIOR o.organization_id_child
824: AND o.org_structure_version_id = PRIOR o.org_structure_version_id
825: AND LEVEL <= NVL (p_plan_rec.hierarchy_levels, LEVEL)
826: START WITH o.organization_id_parent = p_plan_rec.top_organization_id