DBA Data[Home] [Help]

APPS.HR_DELETE dependencies on PER_POSITION_EXTRA_INFO

Line 190: delete per_position_extra_info and

186: 70.45 18-NOV-96 Tmathers Added p_rt_running parameter to allow
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.

Line 1225: DELETE FROM per_position_extra_info poi

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
1228: WHERE pos.position_id = poi.position_id
1229: AND pos.business_group_id = p_business_group_id);