APPS.HR_DU_DO_DATAPUMP dependencies on HR_PUMP_BATCH_LINES

Line 1806: FROM hr_pump_batch_lines

1802: l_line_status VARCHAR2(1);
1803:
1804: CURSOR csr_batch_lines IS
1805: SELECT batch_line_id, line_status
1806: FROM hr_pump_batch_lines
1807: WHERE batch_id = l_batch_id;
1808:
1809: BEGIN
1810: --

Line 1852: DELETE FROM hr_pump_batch_lines

1848: --
1849: END LOOP;
1850: CLOSE csr_batch_lines;
1851:
1852: DELETE FROM hr_pump_batch_lines
1853: WHERE batch_id = l_batch_id;
1854:
1855: --deletes the data held within the pump ranges
1856: DELETE FROM hr_pump_ranges

Line 2072: Select hr_pump_batch_lines_s.nextval

2068: EXIT;
2069: END IF;
2070: END;
2071:
2072: Select hr_pump_batch_lines_s.nextval
2073: INTO l_pump_batch_line_id
2074: FROM dual;
2075:
2076: --change the status of the PC row to show we're processing this