APPS.HRDPP_CREATE_US_SECONDARY_EMP_ dependencies on HR_PUMP_BATCH_EXCEPTIONS

Line 197: delete from hr_pump_batch_exceptions

193: blid number := p_data_pump_batch_line_id;
194: begin
195: if blid is not null then
196: delete from hr_pump_batch_lines where batch_line_id = blid;
197: delete from hr_pump_batch_exceptions
198: where source_type = 'BATCH_LINE' and source_id = blid;
199: end if;
200: insert into hr_pump_batch_lines
201: (batch_id