APPS.HZ_IMP_LOAD_WRAPPER dependencies on HZ_IMP_FINREPORTS_SG

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

654: execute immediate 'ALTER TABLE ' || l_schema || '.HZ_IMP_ADDRESSES_SG TRUNCATE PARTITION batchpar DROP STORAGE';
655: execute immediate 'ALTER TABLE ' || l_schema || '.HZ_IMP_CONTACTPTS_SG TRUNCATE PARTITION batchpar DROP STORAGE';
656: execute immediate 'ALTER TABLE ' || l_schema || '.HZ_IMP_CREDITRTNGS_SG TRUNCATE PARTITION batchpar DROP STORAGE';
657: execute immediate 'ALTER TABLE ' || l_schema || '.HZ_IMP_CLASSIFICS_SG TRUNCATE PARTITION batchpar DROP STORAGE';
658: execute immediate 'ALTER TABLE ' || l_schema || '.HZ_IMP_FINREPORTS_SG TRUNCATE PARTITION batchpar DROP STORAGE';
659: execute immediate 'ALTER TABLE ' || l_schema || '.HZ_IMP_FINNUMBERS_SG TRUNCATE PARTITION batchpar DROP STORAGE';
660: execute immediate 'ALTER TABLE ' || l_schema || '.HZ_IMP_RELSHIPS_SG TRUNCATE PARTITION batchpar DROP STORAGE';
661: execute immediate 'ALTER TABLE ' || l_schema || '.HZ_IMP_CONTACTS_SG TRUNCATE PARTITION batchpar DROP STORAGE';
662: execute immediate 'ALTER TABLE ' || l_schema || '.HZ_IMP_CONTACTROLES_SG TRUNCATE PARTITION batchpar DROP STORAGE';

Line 681: DELETE HZ_IMP_FINREPORTS_SG

677: AND batch_mode_flag = P_BATCH_MODE_FLAG;
678: DELETE HZ_IMP_CLASSIFICS_SG
679: WHERE batch_id = P_BATCH_ID
680: AND batch_mode_flag = P_BATCH_MODE_FLAG;
681: DELETE HZ_IMP_FINREPORTS_SG
682: WHERE batch_id = P_BATCH_ID
683: AND batch_mode_flag = P_BATCH_MODE_FLAG;
684: DELETE HZ_IMP_FINNUMBERS_SG
685: WHERE batch_id = P_BATCH_ID

Line 4058: fnd_stats.gather_table_stats('AR', 'HZ_IMP_FINREPORTS_SG', percent=>5, degree=>4);

4054: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CONTACTROLES_SG', percent=>5, degree=>4);
4055: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CONTACTS_SG', percent=>5, degree=>4);
4056: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CREDITRTNGS_SG', percent=>5, degree=>4);
4057: fnd_stats.gather_table_stats('AR', 'HZ_IMP_FINNUMBERS_SG', percent=>5, degree=>4);
4058: fnd_stats.gather_table_stats('AR', 'HZ_IMP_FINREPORTS_SG', percent=>5, degree=>4);
4059: fnd_stats.gather_table_stats('AR', 'HZ_IMP_RELSHIPS_SG', percent=>5, degree=>4);
4060: fnd_stats.gather_table_stats('AR', 'HZ_ORIG_SYS_REFERENCES', percent=>5, degree=>4);
4061: END IF;
4062:

Line 4694: FROM HZ_IMP_FINREPORTS_SG

4690: AND batch_mode_flag = p_batch_mode_flag
4691: AND rownum = 1)
4692: OR EXISTS (
4693: SELECT 'Y'
4694: FROM HZ_IMP_FINREPORTS_SG
4695: WHERE batch_id = p_batch_id
4696: AND batch_mode_flag = p_batch_mode_flag
4697: AND rownum = 1)
4698: OR EXISTS (

Line 4759: FROM HZ_IMP_FINREPORTS_SG

4755: AND batch_mode_flag = p_batch_mode_flag
4756: AND rownum = 1)
4757: OR EXISTS (
4758: SELECT 'Y'
4759: FROM HZ_IMP_FINREPORTS_SG
4760: WHERE batch_id = p_batch_id
4761: AND batch_mode_flag = p_batch_mode_flag
4762: AND rownum = 1)
4763: OR EXISTS (