APPS.HRDPP_CREATE_POSITION_REQUIREM dependencies on HR_PUMP_BATCH_EXCEPTIONS

Line 145: delete from hr_pump_batch_exceptions

141: blid number := p_data_pump_batch_line_id;
142: begin
143: if blid is not null then
144: delete from hr_pump_batch_lines where batch_line_id = blid;
145: delete from hr_pump_batch_exceptions
146: where source_type = 'BATCH_LINE' and source_id = blid;
147: end if;
148: insert into hr_pump_batch_lines
149: (batch_id