APPS.HRDPP_INSERT_EXTERNAL_EFFORT_L dependencies on HR_PUMP_BATCH_EXCEPTIONS

Line 117: delete from hr_pump_batch_exceptions

113: blid number := p_data_pump_batch_line_id;
114: begin
115: if blid is not null then
116: delete from hr_pump_batch_lines where batch_line_id = blid;
117: delete from hr_pump_batch_exceptions
118: where source_type = 'BATCH_LINE' and source_id = blid;
119: end if;
120: insert into hr_pump_batch_lines
121: (batch_id