APPS.HR_SECURITY_INTERNAL dependencies on HR_ALL_POSITIONS_F

Line 3823: FROM hr_all_positions_f hapf

3819: -- Determines whether this position's organization is visible.
3820: --
3821: CURSOR csr_pos_org_visible IS
3822: SELECT hapf.position_id
3823: FROM hr_all_positions_f hapf
3824: WHERE hapf.position_id = p_position_id
3825: AND p_effective_date BETWEEN
3826: hapf.effective_start_date AND hapf.effective_end_date
3827: AND hr_security_internal.show_organization

Line 3877: FROM hr_all_positions_f hapf

3873: START WITH p.parent_position_id = p_top_position_id
3874: AND p.pos_structure_version_id = p_pos_structure_version_id
3875: AND EXISTS
3876: (SELECT null
3877: FROM hr_all_positions_f hapf
3878: WHERE hapf.position_id = p.subordinate_position_id
3879: AND p_effective_date BETWEEN
3880: hapf.effective_start_date AND hapf.effective_end_date
3881: AND hr_security_internal.show_organization

Line 9231: -- Changes 02-Oct-99 SCNair (per_positions to hr_all_positions_f) date track position req.

9227: WHERE pl.person_id = pevrec.person_id;
9228: END LOOP;
9229: hr_utility.set_location(l_proc,50);
9230: --
9231: -- Changes 02-Oct-99 SCNair (per_positions to hr_all_positions_f) date track position req.
9232: --
9233: DELETE FROM per_position_list pol
9234: WHERE EXISTS ( SELECT ''
9235: FROM hr_all_positions_f pos

Line 9235: FROM hr_all_positions_f pos

9231: -- Changes 02-Oct-99 SCNair (per_positions to hr_all_positions_f) date track position req.
9232: --
9233: DELETE FROM per_position_list pol
9234: WHERE EXISTS ( SELECT ''
9235: FROM hr_all_positions_f pos
9236: WHERE pos.position_id = pol.position_id
9237: AND pos.business_group_id = p_business_group_id);
9238: --
9239: hr_utility.set_location('hr_delete.delete_security_list_for_bg',6);