eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_SECURITY_INTERNAL dependencies on PER_POS_STRUCTURE_ELEMENTS

Line 3870: FROM per_pos_structure_elements p

3866: -- organization can be seen.
3867: --
3868: CURSOR csr_get_restricted_pos IS
3869: SELECT p.subordinate_position_id
3870: FROM per_pos_structure_elements p
3871: CONNECT BY p.parent_position_id = PRIOR p.subordinate_position_id
3872: AND p.pos_structure_version_id = PRIOR p.pos_structure_version_id
3873: START WITH p.parent_position_id = p_top_position_id
3874: AND p.pos_structure_version_id = p_pos_structure_version_id

Line 3891: FROM per_pos_structure_elements p

3887: -- not secure by organizations.
3888: --
3889: CURSOR csr_get_all_pos IS
3890: SELECT p.subordinate_position_id
3891: FROM per_pos_structure_elements p
3892: CONNECT BY p.parent_position_id = PRIOR p.subordinate_position_id
3893: AND p.pos_structure_version_id = PRIOR p.pos_structure_version_id
3894: START WITH p.parent_position_id = p_top_position_id
3895: AND p.pos_structure_version_id = p_pos_structure_version_id;

Line 3902: FROM per_pos_structure_elements p

3898: -- Check if the top position is in the hierarchy.
3899: --
3900: CURSOR csr_top_pos_in_hier IS
3901: SELECT NULL
3902: FROM per_pos_structure_elements p
3903: WHERE p.pos_structure_version_id = p_pos_structure_version_id
3904: AND p.subordinate_position_id = p_top_position_id
3905: AND rownum = 1;
3906: