APPS.HRDPP_UPDATE_PERSON_ADDRESS dependencies on HR_PUMP_BATCH_EXCEPTIONS

Line 147: delete from hr_pump_batch_exceptions

143: L_VALIDATE_COUNTY := 'FALSE';
144: end if;
145: if blid is not null then
146: delete from hr_pump_batch_lines where batch_line_id = blid;
147: delete from hr_pump_batch_exceptions
148: where source_type = 'BATCH_LINE' and source_id = blid;
149: end if;
150: insert into hr_pump_batch_lines
151: (batch_id