APPS.HR_DELETE dependencies on PER_POSITIONS

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 1246: DELETE FROM per_positions

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
1247: WHERE business_group_id = p_business_group_id;
1248: hr_utility.set_location(l_proc,80);
1249: --
1250: DELETE FROM per_job_extra_info jei

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