APPS.HZ_BATCH_IMPORT_PKG dependencies on HZ_IMP_ADDRESSUSES_SG

Line 319: FROM HZ_IMP_ADDRESSUSES_SG

315: AND batch_mode_flag = p_batch_mode_flag
316: AND rownum = 1)
317: OR EXISTS (
318: SELECT 'Y'
319: FROM HZ_IMP_ADDRESSUSES_SG
320: WHERE batch_id = p_batch_id
321: AND batch_mode_flag = p_batch_mode_flag
322: AND rownum = 1);
323:

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

370: execute immediate 'ALTER TABLE ' || l_schema || '.HZ_IMP_FINNUMBERS_SG TRUNCATE PARTITION batchpar DROP STORAGE';
371: execute immediate 'ALTER TABLE ' || l_schema || '.HZ_IMP_RELSHIPS_SG TRUNCATE PARTITION batchpar DROP STORAGE';
372: execute immediate 'ALTER TABLE ' || l_schema || '.HZ_IMP_CONTACTS_SG TRUNCATE PARTITION batchpar DROP STORAGE';
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

Line 407: DELETE HZ_IMP_ADDRESSUSES_SG

403: AND batch_mode_flag = P_BATCH_MODE_FLAG;
404: DELETE HZ_IMP_CONTACTROLES_SG
405: WHERE batch_id = P_BATCH_ID
406: AND batch_mode_flag = P_BATCH_MODE_FLAG;
407: DELETE HZ_IMP_ADDRESSUSES_SG
408: WHERE batch_id = P_BATCH_ID
409: AND batch_mode_flag = P_BATCH_MODE_FLAG;
410:
411: END IF;