APPS.HRDPP_UPDATE_LOCATION dependencies on HR_PUMP_BATCH_EXCEPTIONS
Line 171: delete from hr_pump_batch_exceptions
167: blid number := p_data_pump_batch_line_id;
168: begin
169: if blid is not null then
170: delete from hr_pump_batch_lines where batch_line_id = blid; 171: delete from hr_pump_batch_exceptions 172: where source_type = 'BATCH_LINE' and source_id = blid;
173: end if;
174: insert into hr_pump_batch_lines
175: (batch_id