[Home] [Help]
177: and org_pos_fl = 'O'
178: union
179: select a.subordinate_position_id org_pos_id
180: from per_pos_structure_elements a,
181: per_pos_structure_versions b
182: where a.pos_structure_version_id = b.pos_structure_version_id
183: and a.pos_structure_version_id = org_str_id
184: and child_fl = 'Y'
185: and org_pos_fl = 'P'