APPS.HZ_BATCH_IMPORT_PKG dependencies on HZ_IMP_PARTIES_SG

Line 259: FROM HZ_IMP_PARTIES_SG

255: SELECT 'Y'
256: FROM dual
257: WHERE EXISTS (
258: SELECT 'Y'
259: FROM HZ_IMP_PARTIES_SG
260: WHERE batch_id = p_batch_id
261: AND batch_mode_flag = p_batch_mode_flag
262: AND rownum = 1)
263: OR EXISTS (

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

360: IF P_BATCH_MODE_FLAG = 'Y' THEN
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';

Line 377: DELETE HZ_IMP_PARTIES_SG

373: execute immediate 'ALTER TABLE ' || l_schema || '.HZ_IMP_CONTACTROLES_SG TRUNCATE PARTITION batchpar DROP STORAGE';
374: execute immediate 'ALTER TABLE ' || l_schema || '.HZ_IMP_ADDRESSUSES_SG TRUNCATE PARTITION batchpar DROP STORAGE';
375:
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