PER Position Hierarchy

Description
Categories: BI Publisher, Human Resources
Application: Human Resources
Source: Position Hierarchy Report (XML)
Short Name: PERRPRPH_XML
DB package: PER_PERRPRPH_XMLP_PKG
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
Business Group Id
 
Number
Holders Shown
 
LOV Oracle
Parent Position
 
LOV Oracle
Version
 
LOV Oracle
Position Structure
 
LOV Oracle
Effective Date
 
Date