PER Position Hierarchy

Description
Categories: BI Publisher
Imported from BI Publisher
Description: Position Hierarchy
Application: Human Resources
Source: Position Hierarchy Report (XML)
Short Name: PERRPRPH_XML
DB package: PER_PERRPRPH_XMLP_PKG
Run PER Position Hierarchy and other Oracle EBS reports with Blitz Report™ on our demo environment
select 1 level_no,
       --:p_parent_position_id parent_position_id,
	   to_number(:p_parent_position_id) parent_position_id,
	PER_PERRPRPH_XMLP_PKG.c_nameformula(:p_parent_position_id) C_name,
	PER_PERRPRPH_XMLP_PKG.c_count_subordsformula(:p_parent_position_id) C_count_subords,
	PER_PERRPRPH_XMLP_PKG.c_count_holdersformula(:p_parent_position_id) C_count_holders
from   sys.dual
UNION
select distinct
       level level_no,
       pse.parent_position_id parent_position_id,
		PER_PERRPRPH_XMLP_PKG.c_nameformula(pse.parent_position_id) C_name,
	--PER_PERRPRPH_XMLP_PKG.c_nameformula(:p_parent_position_id) C_name,
		PER_PERRPRPH_XMLP_PKG.c_count_subordsformula(pse.parent_position_id) C_count_subords,
	--PER_PERRPRPH_XMLP_PKG.c_count_subordsformula(:p_parent_position_id) C_count_subords,
		PER_PERRPRPH_XMLP_PKG.c_count_holdersformula(pse.parent_position_id) C_count_holders
	--PER_PERRPRPH_XMLP_PKG.c_count_holdersformula(:p_parent_position_id) C_count_holders
from   per_pos_structure_elements pse
connect by pse.parent_position_id = prior pse.subordinate_position_id
and    pse.pos_structure_version_id = :p_pos_structure_version_id
start with pse.parent_position_id = :p_parent_position_id
and    pse.pos_structure_version_id = :p_pos_structure_version_id
order by 1
Parameter Name SQL text Validation
Effective Date
 
Date
Position Structure
 
LOV Oracle
Version
 
LOV Oracle
Parent Position
 
LOV Oracle
Holders Shown
 
LOV Oracle
Blitz Report™