APPS.HZ_BATCH_IMPORT_PKG dependencies on HZ_IMP_ADDRESSES_SG

Line 265: FROM HZ_IMP_ADDRESSES_SG

261: AND batch_mode_flag = p_batch_mode_flag
262: AND rownum = 1)
263: OR EXISTS (
264: SELECT 'Y'
265: FROM HZ_IMP_ADDRESSES_SG
266: WHERE batch_id = p_batch_id
267: AND batch_mode_flag = p_batch_mode_flag
268: AND rownum = 1)
269: OR EXISTS (

Line 365: execute immediate 'ALTER TABLE ' || l_schema || '.HZ_IMP_ADDRESSES_SG TRUNCATE PARTITION batchpar DROP STORAGE';

361:
362: fnd_file.put_line(FND_FILE.LOG, ' l_schema = ' || l_schema);
363:
364: execute immediate 'ALTER TABLE ' || l_schema || '.HZ_IMP_PARTIES_SG TRUNCATE PARTITION batchpar DROP STORAGE';
365: execute immediate 'ALTER TABLE ' || l_schema || '.HZ_IMP_ADDRESSES_SG TRUNCATE PARTITION batchpar DROP STORAGE';
366: execute immediate 'ALTER TABLE ' || l_schema || '.HZ_IMP_CONTACTPTS_SG TRUNCATE PARTITION batchpar DROP STORAGE';
367: execute immediate 'ALTER TABLE ' || l_schema || '.HZ_IMP_CREDITRTNGS_SG TRUNCATE PARTITION batchpar DROP STORAGE';
368: execute immediate 'ALTER TABLE ' || l_schema || '.HZ_IMP_CLASSIFICS_SG TRUNCATE PARTITION batchpar DROP STORAGE';
369: execute immediate 'ALTER TABLE ' || l_schema || '.HZ_IMP_FINREPORTS_SG TRUNCATE PARTITION batchpar DROP STORAGE';

Line 380: DELETE HZ_IMP_ADDRESSES_SG

376: ELSE
377: DELETE HZ_IMP_PARTIES_SG
378: WHERE batch_id = P_BATCH_ID
379: AND batch_mode_flag = P_BATCH_MODE_FLAG;
380: DELETE HZ_IMP_ADDRESSES_SG
381: WHERE batch_id = P_BATCH_ID
382: AND batch_mode_flag = P_BATCH_MODE_FLAG;
383: DELETE HZ_IMP_CONTACTPTS_SG
384: WHERE batch_id = P_BATCH_ID