APPS.HRDPP_UPDATE_IN_EMP_ASG dependencies on HR_PUMP_BATCH_EXCEPTIONS
Line 195: delete from hr_pump_batch_exceptions
191: blid number := p_data_pump_batch_line_id;
192: begin
193: if blid is not null then
194: delete from hr_pump_batch_lines where batch_line_id = blid; 195: delete from hr_pump_batch_exceptions 196: where source_type = 'BATCH_LINE' and source_id = blid;
197: end if;
198: insert into hr_pump_batch_lines
199: (batch_id