APPS.HRDPP_CREATE_US_PERSON_ADDRESS dependencies on HR_PUMP_BATCH_EXCEPTIONS

Line 152: delete from hr_pump_batch_exceptions

148: L_VALIDATE_COUNTY := 'FALSE';
149: end if;
150: if blid is not null then
151: delete from hr_pump_batch_lines where batch_line_id = blid;
152: delete from hr_pump_batch_exceptions
153: where source_type = 'BATCH_LINE' and source_id = blid;
154: end if;
155: insert into hr_pump_batch_lines
156: (batch_id