APPS.HR_DELETE dependencies on HR_ALL_POSITIONS_F

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

1219: open csr_get_job (p_business_group_id);
1220: fetch csr_get_job into l_exists;
1221: if csr_get_job%found then
1222: --
1223: -- Changes 02-Oct-99 SCNair (per_positions to hr_all_positions_f) date track position req.
1224: --
1225: DELETE FROM per_position_extra_info poi
1226: WHERE EXISTS (SELECT ''
1227: FROM hr_all_positions_f pos

Line 1227: FROM hr_all_positions_f pos

1223: -- Changes 02-Oct-99 SCNair (per_positions to hr_all_positions_f) date track position req.
1224: --
1225: DELETE FROM per_position_extra_info poi
1226: WHERE EXISTS (SELECT ''
1227: FROM hr_all_positions_f pos
1228: WHERE pos.position_id = poi.position_id
1229: AND pos.business_group_id = p_business_group_id);
1230: hr_utility.set_location(l_proc,75);
1231: --

Line 1232: -- PMFLETCH Delete from hr_all_positions_f_tl

1228: WHERE pos.position_id = poi.position_id
1229: AND pos.business_group_id = p_business_group_id);
1230: hr_utility.set_location(l_proc,75);
1231: --
1232: -- PMFLETCH Delete from hr_all_positions_f_tl
1233: --
1234: DELETE FROM hr_all_positions_f_tl pft
1235: WHERE pft.position_id IN (SELECT psf.position_id
1236: FROM hr_all_positions_f psf

Line 1234: DELETE FROM hr_all_positions_f_tl pft

1230: hr_utility.set_location(l_proc,75);
1231: --
1232: -- PMFLETCH Delete from hr_all_positions_f_tl
1233: --
1234: DELETE FROM hr_all_positions_f_tl pft
1235: WHERE pft.position_id IN (SELECT psf.position_id
1236: FROM hr_all_positions_f psf
1237: WHERE psf.business_group_id = p_business_group_id);
1238: hr_utility.set_location(l_proc,76);

Line 1236: FROM hr_all_positions_f psf

1232: -- PMFLETCH Delete from hr_all_positions_f_tl
1233: --
1234: DELETE FROM hr_all_positions_f_tl pft
1235: WHERE pft.position_id IN (SELECT psf.position_id
1236: FROM hr_all_positions_f psf
1237: WHERE psf.business_group_id = p_business_group_id);
1238: hr_utility.set_location(l_proc,76);
1239: --
1240: -- Changes 02-Oct-99 SCNair (delete hr_all_positions_f) date track position req.

Line 1240: -- Changes 02-Oct-99 SCNair (delete hr_all_positions_f) date track position req.

1236: FROM hr_all_positions_f psf
1237: WHERE psf.business_group_id = p_business_group_id);
1238: hr_utility.set_location(l_proc,76);
1239: --
1240: -- Changes 02-Oct-99 SCNair (delete hr_all_positions_f) date track position req.
1241: --
1242: DELETE FROM hr_all_positions_f
1243: WHERE business_group_id = p_business_group_id;
1244: hr_utility.set_location(l_proc,77);

Line 1242: DELETE FROM hr_all_positions_f

1238: hr_utility.set_location(l_proc,76);
1239: --
1240: -- Changes 02-Oct-99 SCNair (delete hr_all_positions_f) date track position req.
1241: --
1242: DELETE FROM hr_all_positions_f
1243: WHERE business_group_id = p_business_group_id;
1244: hr_utility.set_location(l_proc,77);
1245: --
1246: DELETE FROM per_positions

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

2234: WHERE pl.person_id = pevrec.person_id;
2235: END LOOP;
2236: hr_utility.set_location(l_proc,50);
2237: --
2238: -- Changes 02-Oct-99 SCNair (per_positions to hr_all_positions_f) date track position req.
2239: --
2240: DELETE FROM per_position_list pol
2241: WHERE EXISTS ( SELECT ''
2242: FROM hr_all_positions_f pos

Line 2242: FROM hr_all_positions_f pos

2238: -- Changes 02-Oct-99 SCNair (per_positions to hr_all_positions_f) date track position req.
2239: --
2240: DELETE FROM per_position_list pol
2241: WHERE EXISTS ( SELECT ''
2242: FROM hr_all_positions_f pos
2243: WHERE pos.position_id = pol.position_id
2244: AND pos.business_group_id = p_business_group_id);
2245: --
2246: hr_utility.set_location('hr_delete.delete_security_list_for_bg',6);