APPS.HRDPP_CREATE_IN_LOCATION dependencies on HR_PUMP_BATCH_EXCEPTIONS

Line 154: delete from hr_pump_batch_exceptions

150: blid number := p_data_pump_batch_line_id;
151: begin
152: if blid is not null then
153: delete from hr_pump_batch_lines where batch_line_id = blid;
154: delete from hr_pump_batch_exceptions
155: where source_type = 'BATCH_LINE' and source_id = blid;
156: end if;
157: insert into hr_pump_batch_lines
158: (batch_id