APPS.HRDPP_CREATE_LIFE_EVENT_REASON dependencies on HR_PUMP_BATCH_EXCEPTIONS
Line 138: delete from hr_pump_batch_exceptions
134: blid number := p_data_pump_batch_line_id;
135: begin
136: if blid is not null then
137: delete from hr_pump_batch_lines where batch_line_id = blid; 138: delete from hr_pump_batch_exceptions 139: where source_type = 'BATCH_LINE' and source_id = blid;
140: end if;
141: insert into hr_pump_batch_lines
142: (batch_id