DBA Data[Home] [Help]

APPS.AME_APPROVER_TYPE_PKG dependencies on PER_POS_STRUCTURE_ELEMENTS

Line 729: from per_pos_structure_elements str,

725: end;
726: loop
727: select str.parent_position_id
728: into superiorId
729: from per_pos_structure_elements str,
730: per_pos_structure_versions psv
731: where
732: str.subordinate_position_id = origSystemId and
733: str.pos_structure_version_id = psv.pos_structure_version_id and

Line 1561: per_pos_structure_elements str,

1557: superiorOut.orig_system_id,
1558: superiorOut.name,
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

Line 1590: per_pos_structure_elements str,

1586: superiorOut.orig_system_id,
1587: superiorOut.name,
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

Line 1759: per_pos_structure_elements str,

1755: origSystemIdOut,
1756: wfRolesNameOut,
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

Line 1788: per_pos_structure_elements str,

1784: origSystemIdOut,
1785: wfRolesNameOut,
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