APPS.HZ_IMP_LOAD_WRAPPER dependencies on HZ_IMP_FINNUMBERS_SG

Line 659: execute immediate 'ALTER TABLE ' || l_schema || '.HZ_IMP_FINNUMBERS_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';
663: execute immediate 'ALTER TABLE ' || l_schema || '.HZ_IMP_ADDRESSUSES_SG TRUNCATE PARTITION batchpar DROP STORAGE';

Line 684: DELETE HZ_IMP_FINNUMBERS_SG

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
686: AND batch_mode_flag = P_BATCH_MODE_FLAG;
687: DELETE HZ_IMP_RELSHIPS_SG
688: WHERE batch_id = P_BATCH_ID

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

4053: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CONTACTPTS_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;

Line 4700: FROM HZ_IMP_FINNUMBERS_SG

4696: AND batch_mode_flag = p_batch_mode_flag
4697: AND rownum = 1)
4698: OR EXISTS (
4699: SELECT 'Y'
4700: FROM HZ_IMP_FINNUMBERS_SG
4701: WHERE batch_id = p_batch_id
4702: AND batch_mode_flag = p_batch_mode_flag
4703: AND rownum = 1)
4704: OR EXISTS (

Line 4765: FROM HZ_IMP_FINNUMBERS_SG

4761: AND batch_mode_flag = p_batch_mode_flag
4762: AND rownum = 1)
4763: OR EXISTS (
4764: SELECT 'Y'
4765: FROM HZ_IMP_FINNUMBERS_SG
4766: WHERE batch_id = p_batch_id
4767: AND batch_mode_flag = p_batch_mode_flag
4768: AND rownum = 1)
4769: OR EXISTS (