APPS.AME_APPROVER_TYPE_PKG dependencies on PER_POSITION_STRUCTURES

Line 737: from per_position_structures

733: str.pos_structure_version_id = psv.pos_structure_version_id and
734: trunc(sysdate) between psv.date_from and nvl( psv.date_to , sysdate) and
735: psv.position_structure_id =
736: (select position_structure_id
737: from per_position_structures
738: where
739: ((positionStructureId is not null and
740: position_structure_id = positionStructureId) or
741: (positionStructureId is null and

Line 1563: per_position_structures pst,

1559: superiorOut.display_name
1560: from
1561: per_pos_structure_elements str,
1562: per_pos_structure_versions psv,
1563: per_position_structures pst,
1564: wf_roles
1565: where
1566: str.subordinate_position_id = approverIn.orig_system_id and
1567: str.business_group_id =

Line 1592: per_position_structures pst,

1588: superiorOut.display_name
1589: from
1590: per_pos_structure_elements str,
1591: per_pos_structure_versions psv,
1592: per_position_structures pst,
1593: wf_roles
1594: where
1595: str.subordinate_position_id = approverIn.orig_system_id and
1596: str.pos_structure_version_id = psv.pos_structure_version_id and

Line 1761: per_position_structures pst,

1757: displayNameOut
1758: from
1759: per_pos_structure_elements str,
1760: per_pos_structure_versions psv,
1761: per_position_structures pst,
1762: wf_roles
1763: where
1764: str.subordinate_position_id = origSystemIdIn and
1765: str.business_group_id =

Line 1790: per_position_structures pst,

1786: displayNameOut
1787: from
1788: per_pos_structure_elements str,
1789: per_pos_structure_versions psv,
1790: per_position_structures pst,
1791: wf_roles
1792: where
1793: str.subordinate_position_id = origSystemIdIn and
1794: str.pos_structure_version_id = psv.pos_structure_version_id and