APPS.HRDPP_UPDATE_US_EMP_ASG dependencies on HR_PUMP_BATCH_EXCEPTIONS

Line 174: delete from hr_pump_batch_exceptions

170: blid number := p_data_pump_batch_line_id;
171: begin
172: if blid is not null then
173: delete from hr_pump_batch_lines where batch_line_id = blid;
174: delete from hr_pump_batch_exceptions
175: where source_type = 'BATCH_LINE' and source_id = blid;
176: end if;
177: insert into hr_pump_batch_lines
178: (batch_id