APPS.HZ_BATCH_IMPORT_PKG dependencies on HZ_IMP_FINNUMBERS_SG

Line 289: FROM HZ_IMP_FINNUMBERS_SG

285: AND batch_mode_flag = p_batch_mode_flag
286: AND rownum = 1)
287: OR EXISTS (
288: SELECT 'Y'
289: FROM HZ_IMP_FINNUMBERS_SG
290: WHERE batch_id = p_batch_id
291: AND batch_mode_flag = p_batch_mode_flag
292: AND rownum = 1)
293: OR EXISTS (

Line 370: execute immediate 'ALTER TABLE ' || l_schema || '.HZ_IMP_FINNUMBERS_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';
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';

Line 395: DELETE HZ_IMP_FINNUMBERS_SG

391: AND batch_mode_flag = P_BATCH_MODE_FLAG;
392: DELETE HZ_IMP_FINREPORTS_SG
393: WHERE batch_id = P_BATCH_ID
394: AND batch_mode_flag = P_BATCH_MODE_FLAG;
395: DELETE HZ_IMP_FINNUMBERS_SG
396: WHERE batch_id = P_BATCH_ID
397: AND batch_mode_flag = P_BATCH_MODE_FLAG;
398: DELETE HZ_IMP_RELSHIPS_SG
399: WHERE batch_id = P_BATCH_ID