APPS.AME_APPROVER_TYPE_PKG dependencies on PER_POS_STRUCTURE_VERSIONS

Line 730: per_pos_structure_versions psv

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

Line 1562: per_pos_structure_versions psv,

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

Line 1591: per_pos_structure_versions psv,

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

Line 1760: per_pos_structure_versions psv,

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

Line 1789: per_pos_structure_versions psv,

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