DBA Data[Home] [Help]

APPS.AME_APPROVER_TYPE_PKG dependencies on PER_POS_STRUCTURE_ELEMENTS

Line 685: from per_pos_structure_elements str,

681: ame_engine.getHeaderAttValue2(attributeNameIn => ame_util.nonDefPosStructureAttr);
682: loop
683: select str.parent_position_id
684: into superiorId
685: from per_pos_structure_elements str,
686: per_pos_structure_versions psv
687: where
688: str.subordinate_position_id = origSystemId and
689: str.pos_structure_version_id = psv.pos_structure_version_id and

Line 1517: per_pos_structure_elements str,

1513: superiorOut.orig_system_id,
1514: superiorOut.name,
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

Line 1546: per_pos_structure_elements str,

1542: superiorOut.orig_system_id,
1543: superiorOut.name,
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

Line 1710: per_pos_structure_elements str,

1706: origSystemIdOut,
1707: wfRolesNameOut,
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

Line 1739: per_pos_structure_elements str,

1735: origSystemIdOut,
1736: wfRolesNameOut,
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