APPS.HRDPP_CREATE_CN_PERSON_ADDRESS dependencies on HR_PUMP_BATCH_EXCEPTIONS

Line 149: delete from hr_pump_batch_exceptions

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