APPS.HR_DELETE dependencies on PER_JOB_EXTRA_INFO

Line 191: per_job_extra_info.

187: Rt's once again to be re-runnable.
188: 70.46 12-MAR-97 DLo 1 Added delete statements to
189: delete_job_direct to
190: delete per_position_extra_info and
191: per_job_extra_info.
192: 2 Added delete statement to
193: delete_person_direct to delete
194: per_people_extra_info.
195: 110.1 27-JAN-97 N.Bristow Now deleting balance types correctly.

Line 1250: DELETE FROM per_job_extra_info jei

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
1251: WHERE EXISTS (SELECT ''
1252: FROM per_jobs job
1253: WHERE job.job_id = jei.job_id
1254: AND job.business_group_id = p_business_group_id);