APPS.AME_APPROVER_TYPE_PKG dependencies on PER_POS_STRUCTURE_VERSIONS

Line 686: per_pos_structure_versions psv

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
690: trunc(sysdate) between psv.date_from and nvl( psv.date_to , sysdate) and

Line 1518: per_pos_structure_versions psv,

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
1522: str.subordinate_position_id = approverIn.orig_system_id and

Line 1547: per_pos_structure_versions psv,

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
1551: str.subordinate_position_id = approverIn.orig_system_id and

Line 1711: per_pos_structure_versions psv,

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
1715: str.subordinate_position_id = origSystemIdIn and

Line 1740: per_pos_structure_versions psv,

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
1744: str.subordinate_position_id = origSystemIdIn and