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 3830: FROM per_pos_structure_elements p

3826: -- organization can be seen.
3827: --
3828: CURSOR csr_get_restricted_pos IS
3829: SELECT p.subordinate_position_id
3830: FROM per_pos_structure_elements p
3831: CONNECT BY p.parent_position_id = PRIOR p.subordinate_position_id
3832: AND p.pos_structure_version_id = PRIOR p.pos_structure_version_id
3833: START WITH p.parent_position_id = p_top_position_id
3834: AND p.pos_structure_version_id = p_pos_structure_version_id

Line 3851: FROM per_pos_structure_elements p

3847: -- not secure by organizations.
3848: --
3849: CURSOR csr_get_all_pos IS
3850: SELECT p.subordinate_position_id
3851: FROM per_pos_structure_elements p
3852: CONNECT BY p.parent_position_id = PRIOR p.subordinate_position_id
3853: AND p.pos_structure_version_id = PRIOR p.pos_structure_version_id
3854: START WITH p.parent_position_id = p_top_position_id
3855: AND p.pos_structure_version_id = p_pos_structure_version_id;

Line 3862: FROM per_pos_structure_elements p

3858: -- Check if the top position is in the hierarchy.
3859: --
3860: CURSOR csr_top_pos_in_hier IS
3861: SELECT NULL
3862: FROM per_pos_structure_elements p
3863: WHERE p.pos_structure_version_id = p_pos_structure_version_id
3864: AND p.subordinate_position_id = p_top_position_id
3865: AND rownum = 1;
3866: