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