DBA Data[Home] [Help]

APPS.HR_REPORTS dependencies on PER_ORG_STRUCTURE_ELEMENTS

Line 634: from per_org_structure_elements ose

630: begin
631: hr_utility.set_location('hr_reports.count_org_subordinates',10);
632: select nvl(count(*),0)
633: into v_subordinate_count
634: from per_org_structure_elements ose
635: connect by ose.organization_id_parent = prior ose.organization_id_child
636: and ose.org_structure_version_id = p_org_structure_version_id
637: start with ose.organization_id_parent = p_parent_organization_id
638: and ose.org_structure_version_id = p_org_structure_version_id;