[Home] [Help]
689: str.pos_structure_version_id = psv.pos_structure_version_id and
690: trunc(sysdate) between psv.date_from and nvl( psv.date_to , sysdate) and
691: psv.position_structure_id =
692: (select position_structure_id
693: from per_position_structures
694: where
695: ((positionStructureId is not null and
696: position_structure_id = positionStructureId) or
697: (positionStructureId is null and
1515: superiorOut.display_name
1516: from
1517: per_pos_structure_elements str,
1518: per_pos_structure_versions psv,
1519: per_position_structures pst,
1520: wf_roles
1521: where
1522: str.subordinate_position_id = approverIn.orig_system_id and
1523: str.business_group_id =
1544: superiorOut.display_name
1545: from
1546: per_pos_structure_elements str,
1547: per_pos_structure_versions psv,
1548: per_position_structures pst,
1549: wf_roles
1550: where
1551: str.subordinate_position_id = approverIn.orig_system_id and
1552: str.pos_structure_version_id = psv.pos_structure_version_id and
1708: displayNameOut
1709: from
1710: per_pos_structure_elements str,
1711: per_pos_structure_versions psv,
1712: per_position_structures pst,
1713: wf_roles
1714: where
1715: str.subordinate_position_id = origSystemIdIn and
1716: str.business_group_id =
1737: displayNameOut
1738: from
1739: per_pos_structure_elements str,
1740: per_pos_structure_versions psv,
1741: per_position_structures pst,
1742: wf_roles
1743: where
1744: str.subordinate_position_id = origSystemIdIn and
1745: str.pos_structure_version_id = psv.pos_structure_version_id and