APPS.HRDPP_UPDATE_COMPETENCE dependencies on HR_PUMP_BATCH_EXCEPTIONS
Line 188: delete from hr_pump_batch_exceptions
184: blid number := p_data_pump_batch_line_id;
185: begin
186: if blid is not null then
187: delete from hr_pump_batch_lines where batch_line_id = blid; 188: delete from hr_pump_batch_exceptions 189: where source_type = 'BATCH_LINE' and source_id = blid;
190: end if;
191: insert into hr_pump_batch_lines
192: (batch_id