APPS.HRDPP_UPDATE_LIFE_EVENT_REASON dependencies on HR_PUMP_BATCH_EXCEPTIONS

Line 144: delete from hr_pump_batch_exceptions

140: blid number := p_data_pump_batch_line_id;
141: begin
142: if blid is not null then
143: delete from hr_pump_batch_lines where batch_line_id = blid;
144: delete from hr_pump_batch_exceptions
145: where source_type = 'BATCH_LINE' and source_id = blid;
146: end if;
147: insert into hr_pump_batch_lines
148: (batch_id