DBA Data[Home] [Help]

APPS.HR_PERF_MGMT_PLAN_INTERNAL dependencies on PER_ORG_STRUCTURE_ELEMENTS

Line 526: FROM per_org_structure_elements o

522: ppf.current_employee_flag = 'Y' or ppf.current_npw_flag = 'Y') )) )
523: AND asg.organization_id in
524: (select o.organization_id_child from
525: (SELECT o.organization_id_child
526: FROM per_org_structure_elements o
527: CONNECT BY o.organization_id_parent = PRIOR o.organization_id_child
528: AND o.org_structure_version_id = PRIOR o.org_structure_version_id
529: AND LEVEL <= NVL(p_plan_rec.hierarchy_levels, LEVEL)
530: START WITH o.organization_id_parent = p_plan_rec.top_organization_id