Some important
queries related to po_fill_emp_hierarchy
in oracle purchasing
/* Get the list of all
the position hierarchies. */
SELECT pps.position_structure_id, ppsv.pos_structure_version_id
FROM
per_position_structures pps,
per_pos_structure_versions ppsv,
financials_system_parameters fsp
