32: select str.parent_position_id
33: from
34: per_pos_structure_elements str,
35: per_pos_structure_versions psv,
36: per_position_structures pst
37: where
38: str.subordinate_position_id = positionIdIn
39: and str.pos_structure_version_id = psv.pos_structure_version_id
40: and pst.position_structure_id = psv.position_structure_id
44: select str.parent_position_id
45: from
46: per_pos_structure_elements str,
47: per_pos_structure_versions psv,
48: per_position_structures pst
49: where
50: str.subordinate_position_id = positionIdIn
51: and str.pos_structure_version_id = psv.pos_structure_version_id
52: and psv.position_structure_id = pst.position_structure_id