APPS.HR_SECURITY_INTERNAL dependencies on HR_ALL_POSITIONS_F

Line 3783: FROM hr_all_positions_f hapf

3779: -- Determines whether this position's organization is visible.
3780: --
3781: CURSOR csr_pos_org_visible IS
3782: SELECT hapf.position_id
3783: FROM hr_all_positions_f hapf
3784: WHERE hapf.position_id = p_position_id
3785: AND p_effective_date BETWEEN
3786: hapf.effective_start_date AND hapf.effective_end_date
3787: AND hr_security_internal.show_organization

Line 3837: FROM hr_all_positions_f hapf

3833: START WITH p.parent_position_id = p_top_position_id
3834: AND p.pos_structure_version_id = p_pos_structure_version_id
3835: AND EXISTS
3836: (SELECT null
3837: FROM hr_all_positions_f hapf
3838: WHERE hapf.position_id = p.subordinate_position_id
3839: AND p_effective_date BETWEEN
3840: hapf.effective_start_date AND hapf.effective_end_date
3841: AND hr_security_internal.show_organization

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

8363: WHERE pl.person_id = pevrec.person_id;
8364: END LOOP;
8365: hr_utility.set_location(l_proc,50);
8366: --
8367: -- Changes 02-Oct-99 SCNair (per_positions to hr_all_positions_f) date track position req.
8368: --
8369: DELETE FROM per_position_list pol
8370: WHERE EXISTS ( SELECT ''
8371: FROM hr_all_positions_f pos

Line 8371: FROM hr_all_positions_f pos

8367: -- Changes 02-Oct-99 SCNair (per_positions to hr_all_positions_f) date track position req.
8368: --
8369: DELETE FROM per_position_list pol
8370: WHERE EXISTS ( SELECT ''
8371: FROM hr_all_positions_f pos
8372: WHERE pos.position_id = pol.position_id
8373: AND pos.business_group_id = p_business_group_id);
8374: --
8375: hr_utility.set_location('hr_delete.delete_security_list_for_bg',6);