APPS.HRDPP_CREATE_COMPETENCE_ELEMEN dependencies on HR_PUMP_BATCH_EXCEPTIONS

Line 157: delete from hr_pump_batch_exceptions

153: blid number := p_data_pump_batch_line_id;
154: begin
155: if blid is not null then
156: delete from hr_pump_batch_lines where batch_line_id = blid;
157: delete from hr_pump_batch_exceptions
158: where source_type = 'BATCH_LINE' and source_id = blid;
159: end if;
160: insert into hr_pump_batch_lines
161: (batch_id