APPS.HRDPP_CREATE_IN_PASSPORT_DETAI dependencies on HR_PUMP_BATCH_EXCEPTIONS

Line 116: delete from hr_pump_batch_exceptions

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