DBA Data[Home] [Help]

APPS.AME_POSITION_LEVEL_HANDLER dependencies on PER_POSITION_STRUCTURES

Line 36: per_position_structures pst

32: select str.parent_position_id
33: from
34: per_pos_structure_elements str,
35: per_pos_structure_versions psv,
36: per_position_structures pst
37: where
38: str.subordinate_position_id = positionIdIn
39: and str.pos_structure_version_id = psv.pos_structure_version_id
40: and pst.position_structure_id = psv.position_structure_id

Line 48: per_position_structures pst

44: select str.parent_position_id
45: from
46: per_pos_structure_elements str,
47: per_pos_structure_versions psv,
48: per_position_structures pst
49: where
50: str.subordinate_position_id = positionIdIn
51: and str.pos_structure_version_id = psv.pos_structure_version_id
52: and psv.position_structure_id = pst.position_structure_id