APPS.HRDPP_CREATE_LOCATION dependencies on HR_PUMP_BATCH_EXCEPTIONS

Line 168: delete from hr_pump_batch_exceptions

164: blid number := p_data_pump_batch_line_id;
165: begin
166: if blid is not null then
167: delete from hr_pump_batch_lines where batch_line_id = blid;
168: delete from hr_pump_batch_exceptions
169: where source_type = 'BATCH_LINE' and source_id = blid;
170: end if;
171: insert into hr_pump_batch_lines
172: (batch_id