PER Organization Hierarchy (1)

Description
Categories: BI Publisher, Human Resources
Application: Human Resources
Source: Organization Hierarchy Report (XML)
Short Name: PERRPROH_XML
DB package: PER_PERRPROH_XMLP_PKG
select level_no, organization_id_parent,
	PER_PERRPROH_XMLP_PKG.c_nameformula(organization_id_parent) C_name,
	PER_PERRPROH_XMLP_PKG.c_count_managersformula(organization_id_parent) C_count_managers,
	PER_PERRPROH_XMLP_PKG.c_count_org_subordsformula(organization_id_parent) C_count_org_subords,
	PER_PERRPROH_XMLP_PKG.C_type_p C_type
from (select to_number(1) level_no,
       to_number(:p_parent_organization_id) organization_id_parent
from   sys.dual
UNION
select distinct
       to_number(level) level_no,
       to_number(ose.organization_id_parent) organization_id_parent
from   per_org_structure_elements ose
connect by ose.organization_id_parent = prior ose.organization_id_child
and    ose.org_structure_version_id = :p_org_structure_version_id
start with ose.organization_id_parent = :p_parent_organization_id
and    ose.org_structure_version_id = :p_org_structure_version_id
order by 1)
Parameter Name SQL text Validation
Business Group Id
 
Number
Managers Shown
 
LOV Oracle
Parent Organization
 
LOV Oracle
Version
 
LOV Oracle
Organization Structure
 
LOV Oracle
Effective Date
 
Date