APPS.HZ_BATCH_IMPORT_PKG dependencies on HZ_IMP_FINREPORTS_SG

Line 283: FROM HZ_IMP_FINREPORTS_SG

279: AND batch_mode_flag = p_batch_mode_flag
280: AND rownum = 1)
281: OR EXISTS (
282: SELECT 'Y'
283: FROM HZ_IMP_FINREPORTS_SG
284: WHERE batch_id = p_batch_id
285: AND batch_mode_flag = p_batch_mode_flag
286: AND rownum = 1)
287: OR EXISTS (

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

Line 392: DELETE HZ_IMP_FINREPORTS_SG

388: AND batch_mode_flag = P_BATCH_MODE_FLAG;
389: DELETE HZ_IMP_CLASSIFICS_SG
390: WHERE batch_id = P_BATCH_ID
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